Restore a PostgreSQL database from a backup file
Create a new PostgreSQL database
Connect to a PostgreSQL database using psql
Create a backup of a PostgreSQL database
pg_dump -U username dbname > backup.sql
Backs up a PostgreSQL database to a file using pg_dump.
Backup database to file
pg_dump -U postgres mydb > mydb_backup.sql
Delete a PostgreSQL database
Show all tables in the current database
Create a new PostgreSQL user