paginated_view (view)
202 rows
This data as json, testall, testnone, testresponse, CSV (advanced)
| content | content_extra |
|---|---|
| 51 | - 51 - |
| 52 | - 52 - |
| 53 | - 53 - |
| 54 | - 54 - |
| 55 | - 55 - |
| 56 | - 56 - |
| 57 | - 57 - |
| 58 | - 58 - |
| 59 | - 59 - |
| 60 | - 60 - |
| 61 | - 61 - |
| 62 | - 62 - |
| 63 | - 63 - |
| 64 | - 64 - |
| 65 | - 65 - |
| 66 | - 66 - |
| 67 | - 67 - |
| 68 | - 68 - |
| 69 | - 69 - |
| 70 | - 70 - |
| 71 | - 71 - |
| 72 | - 72 - |
| 73 | - 73 - |
| 74 | - 74 - |
| 75 | - 75 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS
SELECT
content,
'- ' || content || ' -' AS content_extra
FROM no_primary_key;