Show Menu

Connect with PSQL

PSQL is a command-line interface that comes when you install Postgres on your machine. You can install it by following these instructions.

Install Postgres on a Mac

Open a terminal window and issue these three commands:
/usr/bin/ruby -e "$(curl -fsSL"

brew install postgres

which psql

After issuing these commands, you should see the following:

Install Postgres on a PC

Download and install Postgres from this location .
Edit your path variable:
Add the two lines shown that include "Postgres."
Save your updates, then open a command prompt and type:
psql -V

You should see something like this:
psql (PostgreSQL) 9.5.14

Connect PSQL and Query Service

Return to the Platform UI on the Connect BI Tools page.
Click copy for PSQL Command .
If you are on a PC, use a text editor to remove the line breaks in the command string, then copy the string.
Paste the command string into a terminal or command window and press Enter.
You should see a result like this:
psql (10.5, server 0.1.0)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

If you don't see at least version 10.5, then you need to download that version or newer.