If you are working with a PostgreSQL database as part of your project, you’ll probably need to add or edit data. We recommend using an SQL client to do so. In this guide, we’ll walk you through how to connect to your Postgres database using an SQL client.
In order to connect to your database, you’ll need to get your Postgres credentials. These include:
localhost
or 127.0.0.1
. If your Postgres database is not hosted on your local network, you’ll need the public ip address/hostname of the server on which it is hosted. One way to do this is to run SELECT inet_server_addr()
from your Postgres server’s command lineSELECT * FROM pg_settings WHERE name = ‘port’
For this guide, we’ll be using Arctype, where you can simply click Add a new data source
or Add connection
and choose ‘PostgreSQL’ to begin:
Next, enter the credentials we gathered above:
Once you’re connected, you can easily interact with your PostgreSQL data: