Web App: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
The web application is available at | The web application is available at | ||
https://app.dataislands.com/ | |||
---- | |||
Advanced SQL help | |||
The backend of Data Islands is Postgres SQL servers. | |||
A. Column Names | |||
Column Names are case-sensitive and should be enclosed in double Quotes. | |||
If not you may see the error text | |||
"Query Failed: column "vendorname" does not exist 31" | |||
Example of working SQL | |||
select * from apvendors where "VendorName" ilike '%ma%' |
Revision as of 11:32, 8 July 2024
The web application is available at
Advanced SQL help
The backend of Data Islands is Postgres SQL servers.
A. Column Names
Column Names are case-sensitive and should be enclosed in double Quotes.
If not you may see the error text
"Query Failed: column "vendorname" does not exist 31"
Example of working SQL
select * from apvendors where "VendorName" ilike '%ma%'