Web App: Difference between revisions

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%'

@@ Line 1: / Line 1: @@
 The web application is available at
+https://app.dataislands.com/
+----
+Advanced SQL help
+The backend of Data Islands is Postgres SQL servers.
-https://app.dataislands.com/
+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%'