How to connect to PostgreSQL using psql

This article explains how to use the psql software to establish a connection to a PostgreSQL database from the command line. The psql application offers a quick and simple method for you to access your databases directly. You may run PostgreSQL queries and view the results using the psql interactive terminal. Additionally, psql has several shell-like functions and meta-commands that facilitate the creation of scripts and the automation of various tasks. Kindly click this page to get more information about these commands.

Connecting to PostgreSQL using psql

To connect to PostgreSQL from the command line, follow these steps:

1. Log in to your hostvento Hosting account using SSH.
2. At the command line, type the following command. Replace dbname with the name of the database, and username with the database username:Copypsql dbname username
3. At the Password prompt, type the database user’s password. When you type the correct password, the psql prompt appears.
4. After you access a PostgreSQL database, you can run SQL queries and more. Here are some common psql commands:
   • To view help for psql commands, type \?.
   • To view help for SQL commands, type \h.
   • To view information about the current database connection, type \conninfo.
   • To list the database’s tables and their respective owners, type \dt.
   • To list all of the tables, views, and sequences in the database, type \z.
   • To exit the psql program, type \q.