Create a backup of a PostgreSQL database
Connect to a PostgreSQL database using psql
Create a new PostgreSQL database
Restore a PostgreSQL database from a backup file
psql -U username dbname < backup.sql
Restores a PostgreSQL database from a SQL dump file.
Restore database from file
psql -U postgres mydb < mydb_backup.sql
Delete a PostgreSQL database
Show all tables in the current database
Restore index from snapshot