Search PostgreSQL documentation

pg_dump --passwordCommand-line ToolsPG18-W--password Force pg_dump to prompt for a password before connecting to a database. This option is never essential, since pg_dump will automatically prompt for a password if the server dema…pg_dump › Options pg_dump --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. Defaults to the PGPORT environment variable, if set, or…pg_dump › Options pg_dump --quote-all-identifiersCommand-line ToolsPG18--quote-all-identifiers Force quoting of all identifiers. This option is recommended when dumping a database from a server whose PostgreSQL major version is different from pg_dump's, or when…pg_dump › Options pg_dump --restrict-key=restrict_keyCommand-line ToolsPG18--restrict-key=restrict_key Use the provided string as the psql \restrict key in the dump output. This can only be specified for plain-text dumps, i.e., when --format is set to plain or the …pg_dump › Options pg_dump --role=rolenameCommand-line ToolsPG18--role=rolename Specifies a role name to be used to create the dump. This option causes pg_dump to issue a SET ROLE rolename command after connecting to the database. It is useful when the a…pg_dump › Options pg_dump --rows-per-insert=nrowsCommand-line ToolsPG18--rows-per-insert=nrows Dump data as INSERT commands (rather than COPY). Controls the maximum number of rows per INSERT command. The value specified must be a number greater than zero. Any e…pg_dump › Options pg_dump --schema-onlyCommand-line ToolsPG18-s--schema-only Dump only the object definitions (schema), not data or statistics. This option cannot be used with --data-only or --statistics-only. It is similar to, but for historical reas…pg_dump › Options pg_dump --schema=patternCommand-line ToolsPG18-n pattern--schema=pattern Dump only schemas matching pattern; this selects both the schema itself, and all its contained objects. When this option is not specified, all non-system schemas i…pg_dump › Options pg_dump --section=sectionnameCommand-line ToolsPG18--section=sectionname Only dump the named section. The section name can be pre-data, data, or post-data. This option can be specified more than once to select multiple sections. The default …pg_dump › Options pg_dump --sequence-dataCommand-line ToolsPG18--sequence-data Include sequence data in the dump. This is the default behavior except when --no-data, --schema-only, or --statistics-only is specified.pg_dump › Options pg_dump --serializable-deferrableCommand-line ToolsPG18--serializable-deferrable Use a serializable transaction for the dump, to ensure that the snapshot used is consistent with later database states; but do this by waiting for a point in the tr…pg_dump › Options pg_dump --snapshot=snapshotnameCommand-line ToolsPG18--snapshot=snapshotname Use the specified synchronized snapshot when making a dump of the database (see Table 9.100 for more details). This option is useful when needing to synchronize the d…pg_dump › Options pg_dump --statisticsCommand-line ToolsPG18--statistics Dump optimizer statistics.pg_dump › Options pg_dump --statistics-onlyCommand-line ToolsPG18--statistics-only Dump only the statistics, not the schema (data definitions) or data. Optimizer statistics for tables, materialized views, foreign tables, and indexes are dumped.pg_dump › Options pg_dump --strict-namesCommand-line ToolsPG18--strict-names Require that each extension (-e/--extension), schema (-n/--schema) and table (-t/--table) pattern match at least one extension/schema/table in the database to be dumped. This …pg_dump › Options pg_dump --superuser=usernameCommand-line ToolsPG18-S username--superuser=username Specify the superuser user name to use when disabling triggers. This is relevant only if --disable-triggers is used. (Usually, it's better to leave this out, …pg_dump › Options pg_dump --sync-method=methodCommand-line ToolsPG18--sync-method=method When set to fsync, which is the default, pg_dump --format=directory will recursively open and synchronize all files in the archive directory. On Linux, syncfs may be use…pg_dump › Options pg_dump --table-and-children=patternCommand-line ToolsPG18--table-and-children=pattern This is the same as the -t/--table option, except that it also includes any partitions or inheritance child tables of the table(s) matching the pattern.pg_dump › Options pg_dump --table=patternCommand-line ToolsPG18-t pattern--table=pattern Dump only tables with names matching pattern. Multiple tables can be selected by writing multiple -t switches. The pattern parameter is interpreted as a pattern acc…pg_dump › Options pg_dump --use-set-session-authorizationCommand-line ToolsPG18--use-set-session-authorization Output SQL-standard SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands to determine object ownership. This makes the dump more standards-compa…pg_dump › Options pg_dump --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.pg_dump › Options pg_dump --verboseCommand-line ToolsPG18-v--verbose Specifies verbose mode. This will cause pg_dump to output detailed object comments and start/stop times to the dump file, and progress messages to standard error. Repeating the o…pg_dump › Options pg_dump --versionCommand-line ToolsPG18-V--version Print the pg_dump version and exit.pg_dump › Options pg_dump/pg_dumpall/pg_restoreManual ChaptersPG18E.6.3.7.1. pg_dump/pg_dumpall/pg_restore Add pg_dump option --statistics (Jeff Davis) § § Add pg_dump and pg_dumpall option --sequence-data to dump sequence data that would normally be exclu…pg_dump/pg_dumpall/pg_restore pg_dumpallCommand-line ToolsPG18pg_dumpall pg_dumpall — extract a PostgreSQL database cluster into a script file Synopsis pg_dumpall [connection-option...] [option...]pg_dumpall pg_dumpallManual ChaptersPG18pg_dumpall pg_dumpall — extract a PostgreSQL database cluster into a script file Synopsis pg_dumpall [connection-option...] [option...]pg_dumpall pg_dumpall --attribute-insertsCommand-line ToolsPG18--column-inserts--attribute-inserts Dump data as INSERT commands with explicit column names (INSERT INTO table (column, ...) VALUES ...). This will make restoration very slow; it is mainly u…pg_dumpall › Options pg_dumpall --binary-upgradeCommand-line ToolsPG18--binary-upgrade This option is for use by in-place upgrade utilities. Its use for other purposes is not recommended or supported. The behavior of the option may change in future releases wi…pg_dumpall › Options pg_dumpall --cleanCommand-line ToolsPG18-c--clean Emit SQL commands to DROP all the dumped databases, roles, and tablespaces before recreating them. This option is useful when the restore is to overwrite an existing cluster. If an…pg_dumpall › Options pg_dumpall --data-onlyCommand-line ToolsPG18-a--data-only Dump only the data, not the schema (data definitions) or statistics.pg_dumpall › Options pg_dumpall --database=dbnameCommand-line ToolsPG18-l dbname--database=dbname Specifies the name of the database to connect to for dumping global objects and discovering what other databases should be dumped. If not specified, the postgres d…pg_dumpall › Options pg_dumpall --dbname=connstrCommand-line ToolsPG18-d connstr--dbname=connstr Specifies parameters used to connect to the server, as a connection string; these will override any conflicting command line options. The option is called --dbname…pg_dumpall › Options pg_dumpall --disable-dollar-quotingCommand-line ToolsPG18--disable-dollar-quoting This option disables the use of dollar quoting for function bodies, and forces them to be quoted using SQL standard string syntax.pg_dumpall › Options pg_dumpall --disable-triggersCommand-line ToolsPG18--disable-triggers This option is relevant only when creating a dump with data and without schema. It instructs pg_dumpall to include commands to temporarily disable triggers on the target t…pg_dumpall › Options pg_dumpall --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_dumpall › Options pg_dumpall --exclude-database=patternCommand-line ToolsPG18--exclude-database=pattern Do not dump databases whose name matches pattern. Multiple patterns can be excluded by writing multiple --exclude-database switches. The pattern parameter is inter…pg_dumpall › Options pg_dumpall --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_dumpall › Options pg_dumpall --file=filenameCommand-line ToolsPG18-f filename--file=filename Send output to the specified file. If this is omitted, the standard output is used.pg_dumpall › Options pg_dumpall --filter=filenameCommand-line ToolsPG18--filter=filename Specify a filename from which to read patterns for databases excluded from the dump. The patterns are interpreted according to the same rules as --exclude-database. To read…pg_dumpall › Options pg_dumpall --globals-onlyCommand-line ToolsPG18-g--globals-only Dump only global objects (roles and tablespaces), no databases.pg_dumpall › Options