EPUB | CHM | PDF

TPSQLDump.Properties.DumpFormat

Top Previous Next

Selects the format of the dump output.

Syntax:

TDumpFormat = (dfPlain, dfTarArchive, dfCompressedArchive, dfDirectory);
property DumpFormat : TDumpFormat;

Description:

Selects the format of the dump output. DumpFormat can be one of the following:

dfPlain

Output a plain-text SQL script file (default).

dfTarArchive

Output a tar archive suitable for input into TPSQLRestore or pg_restore. Using this archive format allows reordering and/or exclusion of database objects at the time the database is restored. It is also possible to limit which data is reloaded at restore time.

dfCompressedArchive

Output a custom archive suitable for input into TPSQLRestore or pg_restore. This is the most flexible format in that it allows reordering of loading data as well as object definitions. This format is also compressed by default.

dfDirectory

Output a directory-format archive suitable for input into pg_restore or TPSQLRestore. This will 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 that TPSQLRestore and pg_restore can read. This format is compressed by default.

See also: CompressLevel