Connection
# psql -h <hostname or ip address> -p <port number of remote machine> -d <database name which you want to connect> -U <username of the database server>
psql -h 127.0.0.1 -p 5432 -U adminList databases
List the databases using \l:
\lSwitch database
Switched to the supersecret database:
\c supersecretList database tables
List database tables with \dt:
\dtDescribe a table
See the tableโs structure. As example, there is a table called users:
\d usersGet info from a table
As example, there is a table called users:
select * from users