The output can be formatted as HTML (default), text, or spreadsheet. If a large result set (over 1000 rows) is expected, it is much more efficient to use the text or spreadsheet option rather than HTML. If the spreadsheet option is selected and MS Excel is identified to your browser, Excel will automatically open with the results of the query. If your browser does not know about Excel, a prompt to save the data will be displayed.
SQL
The SQL is ANSI standard with any Postgres extensions you might require. Only "Select" DML is allowed.
Do not enter an ending ";".
Views, in addition to tables can be used in queries. Public views, created by AviationDB, are available and you can create private ones for your own use. See here for more information or go to View Maintenance to display and maintain the views.
See Database Access for more information regarding accessing the data, Database Description for tables and columns in the schema, and Samples for examples of a variety of queries.
Selecting Schema Description will open the ERD in a separate window. Opening multiple table description windows from the ERD, cutting\pasting column and table names is helpful in generating the queries.
Terminate Query
Use this function to terminate a running query. All queries for this user will be immediately terminated. To terminate the query while the output is being downloaded, just press the "Stop" button on your browser.
Note that your account will be charged for all resources used up to the time the query(s) are terminated.
Explain Plan
Use this function to see the access path that the query will use. It will provide some insight as to the cost of the query. Note that all the values are estimates. The "COST" column is not the cost of the query, but an estimate of machine utilization that the optimizer uses to pick the best access path.
View SQL History
This will show a list of all SQL entered today via this page and its cost. It is sorted in date descending sequence and contains the SQL submitted in the last 24 hours. The current CPU limit setting is also displayed. See here for more account information.
Hints
To control run-away queries do not set the "CPU LIMIT" to more than is required. See here for more information.
After the query results are displayed or if an error message is returned, use the "BACK" command on your browser to return to the Query Entry page, which will retain all entered information.
Multiple Query Entry pages can be open at the same time. This can be useful, for example, if a value from a code table is required to format a query.
For frequent users, create a bookmark in your browser to go directly to this page for this URL.
