Online Documentation for SQL Manager for PostgreSQL
Setting additional backup options
This step offers some additional options that may be useful for the database backup operation.
Add create database command
If this option is selected, the CREATE DATABASE statement will be included into the backup script.
Add drop object commands
If this option is selected, the DROP statements will be added for database objects.
Don't use $ quoting
This option disables dollar-quoting in the backup script.
This option disables privilege allocation for database objects in the script.
Don't set object ownership
This option disables object ownership statements for database objects in the script.
Use set session authorization
If this option is selected, the currently set session authorization is used.
Specify the method that will be used to backup data.
Data as COPY statements
Data as INSERT statements
Select this option to disable triggers for the backup session.
Dump table OIDs
If this option is selected, table OIDs (object identifiers) will be dumped as well.
INSERT with column names
If this option is selected, column names will be included into the INSERT statements.
If this option is selected, the backup file will be compressed to the extent specified using the Compress level control.
If this option is selected, BLOBs (binary large objects) will be dumped as well.
No setting tablespace commands
With this option, all objects will be created in whichever tablespace is the default during restore.
This control allows you to set the compression level for the backup file. Move the slider between the 0 and 9 threshold values to select the required compression level value within this scope.
When you are done, click the Next button to proceed to the next step of the wizard.