searchable_view (view)

2 rows sorted by name with . and spaces

View and edit SQL

pk text1 text2 name with . and spaces ▼
1 barry cat terry dog panther
2 terry dog sara weasel puma

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW searchable_view AS
    SELECT * from searchable;
Powered by Datasette · Query took 7.929ms