Web App: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 21: | Line 21: | ||
select * from apvendors where "VendorName" ilike '%ma%' | select * from apvendors where "VendorName" ilike '%ma%' | ||
B. Islands = Tables | |||
An Island is a Table in Postgres | |||
If we run the SQL | |||
select * from apVendorsX where "VendorName" ilike '%ma%' | |||
where apVendorsX is not a valid Island you will see | |||
"Query Failed: island "apvendorsx" does not exist 15" | |||
Latest revision as of 11:35, 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%'
B. Islands = Tables
An Island is a Table in Postgres
If we run the SQL
select * from apVendorsX where "VendorName" ilike '%ma%'
where apVendorsX is not a valid Island you will see
"Query Failed: island "apvendorsx" does not exist 15"
