EMS logo

Produits

SQL Backup for PostgreSQL

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for PostgreSQL

Documentation en ligne

Configuring script structure


Select options for detailed configuring of statements in the backup.

 

Data queries statement

Select statements type for data form the list.

 

COPY

Dump data as COPY command. This is the fastest way to restore data.

 

INSERT

Dump data as INSERT commands. With this option selected the program generates separate commands for each row, which is rather safe, but slow.

 

INSERT with column names

Dump data as INSERT commands with explicit column names (INSERT INTO table (column, ...) VALUES ...). It is safe in case of reordering the columns, but very slow.

Backup tasks - Configuring backup structure

Structure options

checkbox Force to create new database

The script for creating and connecting to the new database will be added.

 

checkbox Include OIDs to table data

Enables dumping of object identifiers (OIDs) for tables.

 

checkbox Drop objects before creation

The script will contain commands to drop database objects before creating them.

 

checkbox Add IF EXISTS

DROP IF EXISTS statements will be generated instead of DROP statements.

 

checkbox Disable triggers temporarily

This option can be enabled only for data dump in plain-text format. It adds command to temporarily disable triggers on the target tables while data is being loaded.

 

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

 

checkbox Disable select tablespace commands

With this option enabled commands for selecting tablespace are not added to the result file.

 

checkbox Force quoting of all identifiers

Adds quotes to all identifiers to keep compatibility between different server versions.

 

<< Previous step


Next step >>