Search PostgreSQL documentation

pg_dump --disable-triggersCommand-line ToolsPG18pg_dump › Optionsdisable-triggers This option is relevant only when creating a dump that includes data but does not include schema. It instructs pg_dump to include commands to temporarily disable triggers on… pg_dump --enable-row-securityCommand-line ToolsPG18pg_dump › Optionsenable-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 dum… pg_dump --encoding=encodingCommand-line ToolsPG18pg_dump › OptionsE 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 set… pg_dump --exclude-extension=patternCommand-line ToolsPG18pg_dump › Optionsexclude-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 ex… pg_dump --exclude-schema=patternCommand-line ToolsPG18pg_dump › OptionsN 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 schema… pg_dump --exclude-table-and-children=patternCommand-line ToolsPG18pg_dump › Optionsexclude-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 pat… pg_dump --exclude-table-data-and-children=patternCommand-line ToolsPG18pg_dump › Optionsexclude-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) m… pg_dump --exclude-table-data=patternCommand-line ToolsPG18pg_dump › Optionsexclude-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 onc… pg_dump --exclude-table=patternCommand-line ToolsPG18pg_dump › OptionsT 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 m… pg_dump --extension=patternCommand-line ToolsPG18pg_dump › Optionse 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 ca… pg_dump --extra-float-digits=ndigitsCommand-line ToolsPG18pg_dump › Optionsextra-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 purposes … pg_dump --file=fileCommand-line ToolsPG18pg_dump › Optionsf 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 director… pg_dump --filter=filenameCommand-line ToolsPG18pg_dump › Optionsfilter=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 corresponding … pg_dump --format=formatCommand-line ToolsPG18pg_dump › OptionsF 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 archive… pg_dump --helpCommand-line ToolsPG18pg_dump › Options?--help Show help about pg_dump command line arguments, and exit. pg_dump --host=hostCommand-line ToolsPG18pg_dump › Optionsh 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 default… pg_dump --if-existsCommand-line ToolsPG18pg_dump › Optionsif-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 i… pg_dump --include-foreign-data=foreignserverCommand-line ToolsPG18pg_dump › Optionsinclude-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 --in… pg_dump --insertsCommand-line ToolsPG18pg_dump › Optionsinserts 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 erro… pg_dump --jobs=njobsCommand-line ToolsPG18pg_dump › Optionsj 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 database… pg_dump --load-via-partition-rootCommand-line ToolsPG18pg_dump › Optionsload-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 partition … pg_dump --lock-wait-timeout=timeoutCommand-line ToolsPG18pg_dump › Optionslock-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 may… pg_dump --no-aclCommand-line ToolsPG18pg_dump › Optionsx--no-privileges--no-acl Prevent dumping of access privileges (grant/revoke commands). pg_dump --no-blobsCommand-line ToolsPG18pg_dump › OptionsB--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 do… pg_dump --no-commentsCommand-line ToolsPG18pg_dump › Optionsno-comments Do not dump COMMENT commands. pg_dump --no-dataCommand-line ToolsPG18pg_dump › Optionsno-data Do not dump data. pg_dump --no-ownerCommand-line ToolsPG18pg_dump › OptionsO--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 ownership… pg_dump --no-passwordCommand-line ToolsPG18pg_dump › Optionsw--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 wil… pg_dump --no-policiesCommand-line ToolsPG18pg_dump › Optionsno-policies Do not dump row security policies. pg_dump --no-publicationsCommand-line ToolsPG18pg_dump › Optionsno-publications Do not dump publications. pg_dump --no-reconnectCommand-line ToolsPG18pg_dump › OptionsR--no-reconnect This option is obsolete but still accepted for backwards compatibility. pg_dump --no-schemaCommand-line ToolsPG18pg_dump › Optionsno-schema Do not dump schema (data definitions). pg_dump --no-security-labelsCommand-line ToolsPG18pg_dump › Optionsno-security-labels Do not dump security labels. pg_dump --no-statisticsCommand-line ToolsPG18pg_dump › Optionsno-statistics Do not dump statistics. This is the default. pg_dump --no-subscriptionsCommand-line ToolsPG18pg_dump › Optionsno-subscriptions Do not dump subscriptions. pg_dump --no-syncCommand-line ToolsPG18pg_dump › Optionsno-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 operating… pg_dump --no-table-access-methodCommand-line ToolsPG18pg_dump › Optionsno-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 --no-tablespacesCommand-line ToolsPG18pg_dump › Optionsno-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 when … pg_dump --no-toast-compressionCommand-line ToolsPG18pg_dump › Optionsno-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 --no-unlogged-table-dataCommand-line ToolsPG18pg_dump › Optionsno-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 only …