Connect PSQL to Query Service
PSQL is a command-line interface that comes installed when you install PostgreSQL on your machine. This document covers the steps for connecting PSQL with Adobe Experience Platform Query Service.
After installing PSQL on your computer, you are ready to connect PSQL with Query Service. Return to the Platform UI, then select Queries, followed by Credentials.
Under the PSQL Command section, select the Copy to clipboard icon ( ) to copy the command string.
Paste the command string into a terminal or command-line window and press Enter on your keyboard.
PGGSSENCMODE=disable
to your connection string. Additionally, if you are using non-expiring credentials, ensure you replace the password field with the non-expiring credential password. To learn more about non-expiring credentials, please read the credentials guide.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.
Next steps
Now that you’ve connected with Query Service, you can use PSQL to write queries. For more information on how to write and run queries, please read the guide on running queries.