Updated: 28 February 2026
interactive
Start interactive session
psql -U the_userShow all databases in the current server
\l+non-interactive
Run SQL command e.g. restore database backup from SQL in a file
psql -U username -d dbname -f backupfile.sql