apt install postgresql-client
sudo -i -u postgres
psql
\password postgres
createdb <database>
pg_dump -h <host> -p -d <database> -U <user> -W
psql -h localhost -U postgres -f <file>
pg_restore -h localhost -U postgres -d <database> <file>
\list
\c <database>
\dt
SELECT * FROM <table>