EMS logo

Produits

DB Extract for PostgreSQL

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS DB Extract for PostgreSQL

Documentation en ligne

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