Search PostgreSQL documentation

pg_dump --enable-row-securityCommand-line ToolsPG18--enable-row-security This option is relevant only when dumping the contents of a table which has row security. By default, pg_dump will set row_security to off, to ensure that all data is d…pg_dump › Options pg_dump --encoding=encodingCommand-line ToolsPG18-E encoding--encoding=encoding Create the dump in the specified character set encoding. By default, the dump is created in the database encoding. (Another way to get the same result is to se…pg_dump › Options pg_dump --exclude-extension=patternCommand-line ToolsPG18--exclude-extension=pattern Do not dump any extensions matching pattern. The pattern is interpreted according to the same rules as for -e. --exclude-extension can be given more than once to …pg_dump › Options pg_dump --exclude-schema=patternCommand-line ToolsPG18-N pattern--exclude-schema=pattern Do not dump any schemas matching pattern. The pattern is interpreted according to the same rules as for -n. -N can be given more than once to exclude schem…pg_dump › Options pg_dump --exclude-table-and-children=patternCommand-line ToolsPG18--exclude-table-and-children=pattern This is the same as the -T/--exclude-table option, except that it also excludes any partitions or inheritance child tables of the table(s) matching the p…pg_dump › Options pg_dump --exclude-table-data-and-children=patternCommand-line ToolsPG18--exclude-table-data-and-children=pattern This is the same as the --exclude-table-data option, except that it also excludes data of any partitions or inheritance child tables of the table(s)…pg_dump › Options pg_dump --exclude-table-data=patternCommand-line ToolsPG18--exclude-table-data=pattern Do not dump data for any tables matching pattern. The pattern is interpreted according to the same rules as for -t. --exclude-table-data can be given more than o…pg_dump › Options pg_dump --exclude-table=patternCommand-line ToolsPG18-T pattern--exclude-table=pattern Do not dump any tables matching pattern. The pattern is interpreted according to the same rules as for -t. -T can be given more than once to exclude tables …pg_dump › Options pg_dump --extension=patternCommand-line ToolsPG18-e pattern--extension=pattern Dump only extensions matching pattern. When this option is not specified, all non-system extensions in the target database will be dumped. Multiple extensions c…pg_dump › Options pg_dump --extra-float-digits=ndigitsCommand-line ToolsPG18--extra-float-digits=ndigits Use the specified value of extra_float_digits when dumping floating-point data, instead of the maximum available precision. Routine dumps made for backup purpose…pg_dump › Options pg_dump --file=fileCommand-line ToolsPG18-f file--file=file Send output to the specified file. This parameter can be omitted for file based output formats, in which case the standard output is used. It must be given for the directo…pg_dump › Options pg_dump --filter=filenameCommand-line ToolsPG18--filter=filename Specify a filename from which to read patterns for objects to include or exclude from the dump. The patterns are interpreted according to the same rules as the correspondin…pg_dump › Options pg_dump --format=formatCommand-line ToolsPG18-F format--format=format Selects the format of the output. format can be one of the following: pplain Output a plain-text SQL script file (the default). ccustom Output a custom-format archiv…pg_dump › Options pg_dump --helpCommand-line ToolsPG18-?--help Show help about pg_dump command line arguments, and exit.pg_dump › Options pg_dump --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. The defaul…pg_dump › Options pg_dump --if-existsCommand-line ToolsPG18--if-exists Use DROP ... IF EXISTS commands to drop objects in --clean mode. This suppresses “does not exist” errors that might otherwise be reported. This option is not valid unless --clean…pg_dump › Options pg_dump --include-foreign-data=foreignserverCommand-line ToolsPG18--include-foreign-data=foreignserver Dump the data for any foreign table with a foreign server matching foreignserver pattern. Multiple foreign servers can be selected by writing multiple --…pg_dump › Options pg_dump --insertsCommand-line ToolsPG18--inserts Dump data as INSERT commands (rather than COPY). This will make restoration very slow; it is mainly useful for making dumps that can be loaded into non-PostgreSQL databases. Any er…pg_dump › Options pg_dump --jobs=njobsCommand-line ToolsPG18-j njobs--jobs=njobs Run the dump in parallel by dumping njobs tables simultaneously. This option may reduce the time needed to perform the dump but it also increases the load on the databas…pg_dump › Options pg_dump --load-via-partition-rootCommand-line ToolsPG18--load-via-partition-root When dumping data for a table partition, make the COPY or INSERT statements target the root of the partitioning hierarchy that contains it, rather than the partitio…pg_dump › Options pg_dump --lock-wait-timeout=timeoutCommand-line ToolsPG18--lock-wait-timeout=timeout Do not wait forever to acquire shared table locks at the beginning of the dump. Instead fail if unable to lock a table within the specified timeout. The timeout m…pg_dump › Options pg_dump --no-aclCommand-line ToolsPG18-x--no-privileges--no-acl Prevent dumping of access privileges (grant/revoke commands).pg_dump › Options pg_dump --no-blobsCommand-line ToolsPG18-B--no-large-objects--no-blobs (deprecated) Exclude large objects in the dump. When both -b and -B are given, the behavior is to output large objects, when data is being dumped, see the -b d…pg_dump › Options pg_dump --no-commentsCommand-line ToolsPG18--no-comments Do not dump COMMENT commands.pg_dump › Options pg_dump --no-dataCommand-line ToolsPG18--no-data Do not dump data.pg_dump › Options pg_dump --no-ownerCommand-line ToolsPG18-O--no-owner Do not output commands to set ownership of objects to match the original database. By default, pg_dump issues ALTER OWNER or SET SESSION AUTHORIZATION statements to set ownershi…pg_dump › Options pg_dump --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…pg_dump › Options pg_dump --no-policiesCommand-line ToolsPG18--no-policies Do not dump row security policies.pg_dump › Options pg_dump --no-publicationsCommand-line ToolsPG18--no-publications Do not dump publications.pg_dump › Options pg_dump --no-reconnectCommand-line ToolsPG18-R--no-reconnect This option is obsolete but still accepted for backwards compatibility.pg_dump › Options pg_dump --no-schemaCommand-line ToolsPG18--no-schema Do not dump schema (data definitions).pg_dump › Options pg_dump --no-security-labelsCommand-line ToolsPG18--no-security-labels Do not dump security labels.pg_dump › Options pg_dump --no-statisticsCommand-line ToolsPG18--no-statistics Do not dump statistics. This is the default.pg_dump › Options pg_dump --no-subscriptionsCommand-line ToolsPG18--no-subscriptions Do not dump subscriptions.pg_dump › Options pg_dump --no-syncCommand-line ToolsPG18--no-sync By default, pg_dump will wait for all files to be written safely to disk. This option causes pg_dump to return without waiting, which is faster, but means that a subsequent operati…pg_dump › Options pg_dump --no-table-access-methodCommand-line ToolsPG18--no-table-access-method Do not output commands to select table access methods. With this option, all objects will be created with whichever table access method is the default during restore…pg_dump › Options pg_dump --no-tablespacesCommand-line ToolsPG18--no-tablespaces Do not output commands to select tablespaces. With this option, all objects will be created in whichever tablespace is the default during restore. This option is ignored whe…pg_dump › Options pg_dump --no-toast-compressionCommand-line ToolsPG18--no-toast-compression Do not output commands to set TOAST compression methods. With this option, all columns will be restored with the default compression setting.pg_dump › Options pg_dump --no-unlogged-table-dataCommand-line ToolsPG18--no-unlogged-table-data Do not dump the contents of unlogged tables and sequences. This option has no effect on whether or not the table and sequence definitions (schema) are dumped; it onl…pg_dump › Options pg_dump --on-conflict-do-nothingCommand-line ToolsPG18--on-conflict-do-nothing Add ON CONFLICT DO NOTHING to INSERT commands. This option is not valid unless --inserts, --column-inserts or --rows-per-insert is also specified.pg_dump › Options