Quick guide to the PostgreSQL client interface

March 26, 2019 | Leave a comment

Our datasets can be viewed through the SQL interface at db001.gda-score.org. This article gives a few quick pointers on how to use the interface.

On going to db001.gda-score.org for the first time, you may see the following:

Clicking on the server labeled “PostgreSQL” (red arrow) shows a list of available databases:

Clicking on a database (here pseudo_banking) produces a page with a variety of options for viewing the data:

Clicking on the button labeled “SQL”, for instance, provides a text box where SQL queries may be input:

Here we have input the query “select * from accounts limit 10”. After clicking “Execute”, this displays all column values for the first 10 rows of the accounts table in the database pseudo_banking:

Clicking “Edit SQL” displays the SQL query text box again.

Leave a comment

Your email address will not be published. Required fields are marked *