Step 6 - Setting up extraction options
At this step you can set the advanced extraction parameters and define query options for data extraction.
Generate CREATE TABLESPACE statements
Check this option to add the CREATE TABLESPACE statement(s) to the extraction script.
Generate DROP statements
Check the option to add the DROP statements for the extracted objects.
Tick off the option if you want the privileges (permissions on the objects) to be extracted.
Order by dependencies
This option specifies whether objects should be ordered by their dependencies in the result script or not. If this option is disabled the objects will be ordered by OID.
Extract dependent objects
This option determines the usage of dependencies between objects in the extraction process.
CHARACTER and CHARACTER VARYING as CHAR and VARCHAR
Check this option to enable conversion of the corresponding data types in the result script.
Include session user identifier
Setting this option adds the current session user identifier to the extraction script.
Records in Block / Insert COMMIT after each block
These controls allow you to define whether the COMMIT statement is inserted into the script or not, and to define the number of records in each block to be supplemented with this statement.
Delete existing records before insert
Generates the DELETE FROM statements before the INSERT INTO statements.
Use INSERT statements instead of COPY statement
If this option is checked, INSERT INTO statements are generated instead of PostgreSQL COPY statements to populate the extracted tables with data.
This option enables/disables BLOB fields extraction. Please note that in this case the generated SQL script will work correctly on version 8.1 and higher.
Data query options
This grid allows you to specify additional options for the SELECT statements used for data extraction.
This column represents the list of the databases containing the tables selected for data extraction.
By setting non-zero values in this column you can limit the number of records extracted from each table.
This column contains the names of the tables (with the names of the schemas they belong to).
Table Data Filter
Here you can specify the WHERE clauses for data extraction from each of the tables.
Note that you can define data query options not only for a single table, but also for multiple tables at a time by using corresponding items of the context menu of the Data query options grid.
When you are done, press the Next button to proceed to the next step of the wizard.