Web App

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

Anonymous