pg_dump

all

Extract a PostgreSQL database into a script file or other archive file.

Options (7)

-U, --usernameboolean

Same as above, customize username

Example: pg_dump {{[-U|--username]}} {{username}} {{db_name}} > {{output_file.sql}}

-h, --hostboolean

Same as above, customize host and port

Example: pg_dump {{[-h|--host]}} {{host}} {{[-p|--port]}} {{port}} {{db_name}} > {{output_file.sql}}

-p, --portboolean

Same as above, customize host and port

Example: pg_dump {{[-h|--host]}} {{host}} {{[-p|--port]}} {{port}} {{db_name}} > {{output_file.sql}}

-F, --formatboolean

Dump a database into a custom-format archive file

Example: pg_dump {{[-F|--format]}} {{[c|custom]}} {{db_name}} > {{output_file.dump}}

boolean

Dump a database into a custom-format archive file

Example: pg_dump {{[-F|--format]}} {{[c|custom]}} {{db_name}} > {{output_file.dump}}

-a, --data-onlyboolean

Dump only database data into an SQL-script file

Example: pg_dump {{[-a|--data-only]}} {{db_name}} > {{path/to/output_file.sql}}

-s, --schema-onlyboolean

Dump only schema (data definitions) into an SQL-script file

Example: pg_dump {{[-s|--schema-only]}} {{db_name}} > {{path/to/output_file.sql}}

Dump database into an SQL-script file

pg_dump db_name > output_file.sql

Same as above, customize username

pg_dump [-U|--username] username db_name > output_file.sql

Same as above, customize host and port

pg_dump [-h|--host] host [-p|--port] port db_name > output_file.sql

Dump a database into a custom-format archive file

pg_dump [-F|--format] [c|custom] db_name > output_file.dump

Dump only database data into an SQL-script file

pg_dump [-a|--data-only] db_name > path/to/output_file.sql

Dump only schema (data definitions) into an SQL-script file

pg_dump [-s|--schema-only] db_name > path/to/output_file.sql