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
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:
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. all=>
If you don't see at least version 10.5, then you need to download that version or newer.