searchable_view (view)
2 rows sorted by name with . and spaces descending
This data as json, CSV (advanced)
pk | text1 | text2 | name with . and spaces ▲ |
---|---|---|---|
2 | terry dog | sara weasel | puma |
1 | barry cat | terry dog | panther |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW searchable_view AS SELECT * from searchable;