Online Documentation for Data Pump for PostgreSQL

Step 4 - Setting options


At this step of the wizard you can define pump options: database structure conversion options, options pertaining to schemas processing, SQL script execution, data import preferences, server-specific options, and perform source-to-target type mapping.

 

Step 4 - Setting options

 

Convert database structure options

This group of options allows you to customize database structure conversion process.

 

CheckBox Convert names to SQL92 standard

This option brings all the database object names to conformity with SQL92 naming rules.

 

Object names format

The drop-down list allows you to specify whether object names are to be converted to upper/lower case or left without changes (As Is).

 

CheckBox Convert default values

Check this option to convert the default values of the source database to default values for the destination database.

 

Schemas processing

This group of options allows you to specify how PostgreSQL schemas will be processed by the application.

 

RadioButton As is

If this option is selected, the tables will be placed into the default schema in the target database.

RadioButton Use existing schema for import

If this option is selected, the tables will be placed into an existing schema. Use the drop-down list to select the schema in the PostgreSQL database where the source tables are to be pumped into.

RadioButton Import tables to the new schema

If this option is selected, a new schema will be created and the tables will be placed into this schema. Use the edit-box to enter a name for the new schema.

 

Script options

This group of options allows you to customize the SQL script generation and its execution process.

 

CheckBox Enable comments

If this option is selected, comments will be included into the body of the script.

 

CheckBox Show "OK" for successfully executed statements

If this option is selected, records for successfully executed statements will be listed in the Script execution information area at Step 6.

 

CheckBox Always skip successfully executed statements

If this option is selected, all successfully executed statements will be skipped upon subsequent script execution.

 

CheckBox Generate "DROP TABLE" statements

Select the option to add the DROP statements for tables in the script.

 

CheckBox Stop script execution on error

If this option is checked, the script execution will be stopped if an error occurs.

 

Import options

This group of options allows you to customize data import process.

 

CheckBox Clear tables before import data

Select this option to empty the tables in the PostgreSQL database before data import at Step 8.

 

CheckBox Quote source identifiers

This option enables/disables quoting source object identifiers.

If enabled, use the drop-down list to select the preferable value:

  • Default to use the default quotes for the data source being used;
  • one of available quoting patterns: "...", '...', `...`, [...], (...), {...}, <...>;
  • Custom to specify any other characters to be used as left/right quotes.

 

CheckBox Remove trailing spaces

If this option is checked, unused space at the end of source data strings will be cut off.

 

Specific options

This group allows you to define server-specific options.

 

CheckBox Set sequences to max value after import

Use this option to enforce the maximum value for the sequences after the import operation is complete.

 

CheckBox Use COPY statement to import data

Enables PostgreSQL COPY statement instead of INSERT statement. This option can be used to speed up data import process.

 

CheckBox With OIDs

Enable this option to use OIDs (object identifiers) for pumped objects.

 

Press the Global type mapping button to open the Type mapping dialog allowing you to view and edit source-target data type correspondences.

 

When you are done, click the Next button to proceed to editing target objects.