Related

Restore Database

psql

Restore a PostgreSQL database from a backup file

Create Database

psql

Create a new PostgreSQL database

Connect to PostgreSQL

psql

Connect to a PostgreSQL database using psql

psql/backup-db

Backup Database

Create a backup of a PostgreSQL database

backup

Command

pg_dump -U username dbname > backup.sql

Explanation

Backs up a PostgreSQL database to a file using pg_dump.

Examples

Backup database to file

pg_dump -U postgres mydb > mydb_backup.sql

More

Drop Database

psql

Delete a PostgreSQL database

List Tables

psql

Show all tables in the current database

Create User

psql

Create a new PostgreSQL user