This guide shows you how to use a tool called psql to connect to a PostgreSQL database from your computer’s command line. It is like a special program that lets you talk to your databases easily. With psql, you can run commands to ask questions and see the answers from your database. It also has some extra tricks to help you write scripts and do things automatically.
Connecting to PostgreSQL via psql:
To connect to PostgreSQL from the command line, follow these steps-
- Log into your account using SSH.
- In the command line, type this command. Instead of “dbname”, put the name of your database, and instead of “username”, put the database username –
psql dbname username - When it asks for a password, type in the database user’s password. If it is correct, you will see the psql prompt.
- Once you are in a PostgreSQL database, you can do things like running SQL queries.
Here are some useful commands for psql:
To see help for psql commands, type ?.
For help with SQL commands, type \h.
To check info about your current database connection, type \conninfo.
To list the tables in the database along with their owners, type \dt.
To list all the tables, views, and sequences in the database, type \z.
To leave the psql program, type \q.
This way, you can connect to PostgreSQL using psql. Should you encounter any issue, get it solved by our support team at WHUK.