paginated_view (view)
202 rows
This data as json, testall, testnone, testresponse, CSV (advanced)
| content | content_extra |
|---|---|
| 26 | - 26 - |
| 27 | - 27 - |
| 28 | - 28 - |
| 29 | - 29 - |
| 30 | - 30 - |
| 31 | - 31 - |
| 32 | - 32 - |
| 33 | - 33 - |
| 34 | - 34 - |
| 35 | - 35 - |
| 36 | - 36 - |
| 37 | - 37 - |
| 38 | - 38 - |
| 39 | - 39 - |
| 40 | - 40 - |
| 41 | - 41 - |
| 42 | - 42 - |
| 43 | - 43 - |
| 44 | - 44 - |
| 45 | - 45 - |
| 46 | - 46 - |
| 47 | - 47 - |
| 48 | - 48 - |
| 49 | - 49 - |
| 50 | - 50 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS
SELECT
content,
'- ' || content || ' -' AS content_extra
FROM no_primary_key;