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 https://raw.githubusercontent.com/Homebrew/install/master/install)"
brew install postgres
which psql

After issuing these commands, you should see the following:

/usr/local/bin/psql

Install Postgres on a PC

Download and install Postgres from this location.

Edit your path variable:

Image

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.

Image

IMPORTANT

If you are on a PC, use a text editor to remove the line breaks in the command string, then copy the string. Additionally, if you are using version 12.0 or greater, you will need to add PGGSSENCMODE=disable to your connection 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.
all=>

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

On this page