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