EMS logo

Products Navigation

DB Extract for PostgreSQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS DB Extract for PostgreSQL

On-line Documentation

Extract Options section


Section [#ExtractOptions#] stores values set on Step 6 of Wizard application.

 

The configuration parameters are listed below.

 

CreateDatabaseStmt

0 = Do not add CREATE DATABASE statement to the extraction script.

1 = Add CREATE DATABASE statement to the extraction script.

 

 

 

DropTableStmt

0 = Do not add DROP statements for the extracted objects

1 = Add DROP statements for the extracted objects to the result script

 

RecordsInBlock

The number of INSERT statements in a block after which the COMMIT statement is to be added

 

InsertCommit

0 = Do not insert COMMIT statement after each block

1 = Insert COMMIT statement after each block

 

DeleteAllRecords

0 = Do not delete any records from the tables before the INSERT statements

1 = Delete all records from the tables before the INSERT statements

 

Tablespaces

0 = Do not include definition of tablespaces into the extraction script

1 = Include definition of tablespaces into the extraction script

 

Privileges

0 = Do not include access privileges for the extracted objects

1 = Include access privileges for the extracted objects

 

ExtractDependentObjects

0 = Extract dependent objects

1 = Do not extract dependent objects

 

 

 

CharacterAsChar

0 = Do not change CHARACTER and CHAR data types

1 = Change CHARACTER data type to CHARACTER VARYING and CHAR to VARCHAR

 

DescribeOwner

0 = Do not include the session user identifier into the extraction script

1 = Include the session user identifier into the extraction script

 

Inserts

0 = Perform data extraction using a single COPY statement

1 = Perform data extraction using the INSERT INTO statements (one for each record)

 

Blobs

0 = Do not extract BLOB data

1 = Extract BLOB data

 

 

 

 

 

 

 

 


See also:

General and Connection sections

Common Options section

File Options section

Scheduled Task sections

Data Query sections

Databases section