Switch to: V12V11V10V9V8V7V6V5

Create Dump [PostgreSQL] Dialog Help


On this page you can select the kind dump output.

  • Custom – Create custom-format archive.
  • Directory – Create a directory with one file for each table and blob being dumped, plus a so-called Table of Contents file describing the dumped objects in a machine-readable format.
  • Excel – Create dump in Excel format.
  • SQL – Create a plain-text SQL script file.
  • Tar – Create a tar-format archive.


On this page you can select what need to dump.

  • Structure Only – Dump only database objects (tables, triggers, functions etc) without data.
  • Structure And Records – Dump database objects and stored data.
  • Records Only – Dump only data.
  • Dump Blobs – Dump blob records.

Options: Queries

  • Include CREATE DATABASE statement – If ON then the CREATE DATABASE statement will be added to the dump.
  • Clean before restore – Clean (drop) database objects prior to outputting the commands for creating them.
  • Use column inserts – Dump data as INSERT commands with explicit column names
    (INSERT INTO TABLE_NAME (column_name, ...) VALUES ...)
  • Use INSET commands – Dump data as INSERT commands (rather than COPY).

Options: Save

  • Owner – Dump commands to set ownership of objects.
  • Privilege – Dump of access privileges.
  • Tablespace – Dump commands to select tablespaces.
  • Unlogged table data – Dump the contents of unlogged tables.

Options: Misc

  • Disable triggers – Include commands to temporarily disable triggers on the target tables while the data is reloaded.
  • Disable '$' quoting – Disable the use of dollar quoting for function bodies.
  • Use SET SESSION AUTHORIZATION – USE SQL-standard SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands to determine object ownership.
  • With OID's – Dump object identifiers (OIDs) as part of the data for every table.
  • Verbose – Output detailed object comments and start/stop times to the dump file, and progress messages to standard error.
  • Force double quotes on identifiers – Force quoting of all identifiers.


At this page you can determine the location for the dump and the options of the dump file(s).

  • Destination – The path to the dump location.
  • Encoding – Create the dump in the specified character set encoding.
  • Compression – Specify the compression level to use. Zero means no compression.