How to access your managed Postgres database
After you have created your managed Postgres database, you will receive a database URL that you will use to access the data.
To find your database URL:
-
Go to the "Destinations" tab on the sidebar
-
Click on the database in the table
-
Copy the database URL from the top of the page
There are a few ways to access the data:
-
Access the data via your Terminal using
psql
- Learn more on how to access Postgres with
psql
in the official documentation here.
- Learn more on how to access Postgres with
-
Use a Postgres client (like Postico)
- You will be able to create a new Server from the URL, and will be able to start querying your data in seconds.