simple_view (view)

5 rows

View and edit SQL
simple_view

All rows in this view

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

content upper_content
hello HELLO
world WORLD
   
{"row": {"content": "RENDER_CELL_DEMO", "upper_content": "RENDER_CELL_DEMO"}, "column": "content", "table": "simple_view", "database": "fixtures2", "pks": [], "config": null} {"row": {"content": "RENDER_CELL_DEMO", "upper_content": "RENDER_CELL_DEMO"}, "column": "upper_content", "table": "simple_view", "database": "fixtures2", "pks": [], "config": null}
RENDER_CELL_ASYNC_RESULT RENDER_CELL_ASYNC_RESULT
View definition 
CREATE VIEW simple_view AS
    SELECT content, upper(content) AS upper_content FROM simple_primary_key;