Connect PSQL to Query Service

Last update: July 24, 2024

CREATED FOR:

  • User
  • Developer

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.

NOTE
This guide assumes you already have access to PSQL and are familiar with how to use it. More information about PSQL can be found in the official PSQL documentation.

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 ( Copy Icon ) to copy the command string.

The Queries dashboard Credentials tab with the copy icon highlighted.

Paste the command string into a terminal or command-line window and press Enter on your keyboard.

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

More help on this topic

Previous pagePower BI
Next pageRStudio

Experience Platform


B2B Reimagined: Transforming Go-to-Market Strategies for Profitable Growth

Online | Strategy Keynote | General Audience

B2B brands are facing a digital revolution. Buyers expect hyper-relevant content and self-service, while internally AI is transforming...

Wed, Mar 19, 1:00 PM PDT (8:00 PM UTC)

Register

Drive Intelligent Activation and Effective Marketing at Scale with AI in Real-Time CDP

Online | Session | General Audience

Discover how Adobe Real-Time CDP leverages AI to revolutionize customer experiences. Explore the cutting-edge AI-powered features embedded...

Wed, Mar 19, 2:00 PM PDT (9:00 PM UTC)

Register

Connect with Experience League at Summit!

Get front-row access to top sessions, hands-on activities, and networking—wherever you are!

Learn more

Register now