Search PostgreSQL documentation

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 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