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 ▼ |
---|---|
144 | - 144 - |
145 | - 145 - |
146 | - 146 - |
147 | - 147 - |
148 | - 148 - |
149 | - 149 - |
15 | - 15 - |
150 | - 150 - |
151 | - 151 - |
152 | - 152 - |
153 | - 153 - |
154 | - 154 - |
155 | - 155 - |
156 | - 156 - |
157 | - 157 - |
158 | - 158 - |
159 | - 159 - |
16 | - 16 - |
160 | - 160 - |
161 | - 161 - |
162 | - 162 - |
163 | - 163 - |
164 | - 164 - |
165 | - 165 - |
166 | - 166 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS SELECT content, '- ' || content || ' -' AS content_extra FROM no_primary_key;