Query AACT with pSQL

The most fundamental way to access AACT data is by using the standard postgreSQL command line query tool: pSQL. This tool is part of the PostgreSQL client software.

1

Install PostgreSQL Database Platform

The standard PostgreSQL installation includes a number of related tools that you'll need, such as pSQL, createdb & pg_restore. These tools are mentioned throughout the documentation provided on this site; they should all be available to you once PostgreSQL is installed.

AACT is currently running on version 9.5.4 of PostgreSQL; it's recommended you install this version or higher. Refer to PostgreSQL Downloads for free software and installation instructions.

2

Launch pSQL

Once PostgreSQL is installed on your local machine, you can access pSQL from a terminal session by entering the command: psql. To access the AACT cloud-hosted database, open a terminal window and enter the psql command with the following syntax.

  

-> psql --host aact-prod.cr4nrslb1lw7.us-east-1.rds.amazonaws.com --port=5432 --username=aact --dbname=aact psql (9.5.3, server 9.5.4) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) Type "help" for help. aact=> _

The aact=> prompt indicates that you're in a pSQL console session and can enter SQL queries against the AACT database. A simple example:

  

aact=> select count(*) from studies; count -------- 247793 (1 row) aact=> _

Important note: To exit pSQL, enter the (not entirely intuitive) command: \q and hit return.

      

aact=> \q -> _