paginated_view (view)
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
201 rows sorted by content_extra
This data as json, testall, testnone, testresponse, CSV (advanced)
content | content_extra ▼ |
---|---|
121 | - 121 - |
122 | - 122 - |
123 | - 123 - |
124 | - 124 - |
125 | - 125 - |
126 | - 126 - |
127 | - 127 - |
128 | - 128 - |
129 | - 129 - |
13 | - 13 - |
130 | - 130 - |
131 | - 131 - |
132 | - 132 - |
133 | - 133 - |
134 | - 134 - |
135 | - 135 - |
136 | - 136 - |
137 | - 137 - |
138 | - 138 - |
139 | - 139 - |
14 | - 14 - |
140 | - 140 - |
141 | - 141 - |
142 | - 142 - |
143 | - 143 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS SELECT content, '- ' || content || ' -' AS content_extra FROM no_primary_key;