>_ linuxcommand.dev
Startseite pg_dump
Database

pg_dump

PostgreSQL Database Backup

Syntax
$pg_dump [options] [database]
Optionen
-U
-h
-p
-t
--format
Examples
Examples
$pg_dump -U postgres database > backup.sql
Examples
$pg_dump -U postgres --format=c database > backup.dump
Examples
$pg_dump -U postgres -t table_name database > table_backup.sql
Typical use cases
Backup databases
Perform migration
Create backups
Note Creates backups of PostgreSQL databases.
Export