--help, -? | Show help for pg_dump |
--file, -f <filename> | Output file or directory name |
--format, -F <format> | Output file format |
--jobs, -j <num> | Number of parallel job to dump |
--verbose, -v | Verbose mode |
--version, -V | Output version information |
--compress, -Z <level> | Compression level for compressed formats |
--lock-wait-timeout <timeout> | Fail after waiting <timeout> for a table lock |
--no-sync | Do not wait for changes to be written safely to disk |
--data-only, -a | Dump only the data, not the schema |
--blobs, -b | Include large objects in dump |
--no-blobs, -B | Exclude large objects in dump |
--clean, -c | Clean (drop) database objects before recreating |
--create, -C | Include commands to create database in dump |
--extension, -e <pattern> | |
--encoding, -E <encoding> | Dump the data in encoding <encoding> |
--schema, -n <pattern> | |
--exclude-schema, -N <pattern> | |
--no-owner, -O | Skip restoration of object ownership in plain-text format |
--schema-only, -s | Dump only the schema, no data |
--superuser, -S <name> | Superuser user name to use in plain-text format |
--table, -t <table> | |
--exclude-table, -T <table> | |
--no-privileges, -x, --no-acl | Do not dump privileges (grant/revoke) |
--binary-upgrade | For use by upgrade utilities only |
--column-inserts, --attribute-inserts | Dump data as INSERT commands with column names |
--disable-dollar-quoting | Disable dollar quoting, use SQL standard quoting |
--disable-triggers | Disable triggers during data-only restore |
--enable-row-security | Enable row security (dump only content user has access to) |
--exclude-table-data <table> | |
--extra-float-digits <num> | Override default setting for extra_float_digits |
--if-exists | Use IF EXISTS when dropping objects |
--include-foreign-data <pattern> | Include data of foreign tables on foreign servers matching PATTERN |
--inserts | Dump data as INSERT commands, rather than COPY |
--load-via-partition-root | Load partitions via the root table |
--no-comments | Do not dump comments |
--no-publications | Do not dump publications |
--no-security-labels | Do not dump security label assignments |
--no-subscriptions | Do not dump subscriptions |
--no-synchronized-snapshots | Do not use synchronized snapshots in parallel jobs |
--no-tablespaces | Do not dump tablespace assignments |
--no-toast-compression | Do not dump TOAST compression methods |
--no-unlogged-table-data | Do not dump unlogged table data |
--on-conflict-do-nothing | Add ON CONFLICT DO NOTHING to INSERT commands |
--quote-all-identifiers | Quote all identifiers, even if not key words |
--rows-per-insert <numbers> | Number of rows per INSERT; implies --inserts |
--section <section> | Dump named section (pre-data, data, or post-data) |
--serializable-deferrable | Wait until the dump can run without anomalies |
--snapshot <snapshot> | Use given snapshot for the dump |
--strict-names | Require table and/or schema include patterns to match at least one entity each |
--use-set-session-authorization | Use SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands to set ownership |
--dbname, -d <database> | Database to dump |
--host, -h <host> | Database server host or socket directory |
--port, -p <number> | Database server port number |
--username, -U <name> | Connect as specified database user |
--no-password, -w | Never prompt for password |
--password, -W | Force password prompt (should happen automatically) |
--role <name> | Do SET ROLE before dump |