home / fixtures / searchable_view

Menu

searchable_view (view)

2 rows

View and edit SQL

Export data

searchable_view

All rows in this view

TSV All 2 rows
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 2 rows
Comma-separated values, for spreadsheets and other tools
  • JSON All 2 rows
    Rows inside an object, with extra details
    View Download
  • JSON array All 2 rows
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 2 rows
    One JSON object per line
    View Download
  • testall All 2 rows
    View Download
  • testnone All 2 rows
    View Download
  • testresponse All 2 rows
    View Download

pk text1 text2 name with . and spaces
1 barry cat terry dog panther
2 terry dog sara weasel puma
View definition
CREATE VIEW searchable_view AS
    SELECT * from searchable;
Powered by Datasette · Queries took 38.318ms