PowerExchange for PostgreSQL User Guide for PowerCenter

Back Next

Configure PostgreSQL Target Session Properties

You can configure the session properties for a PostgreSQL target on the

Workflow Manager

tab. Define the properties for the target instance in the session.

The following table describes the session properties that you can configure for a PostgreSQL target session:

Session Property	Description
Update Mode	Specifies the mode to write data to PostgreSQL target. You can specify the following modes:- - Update As Update. Updates all rows flagged for update if the entries exist. - Update Else Insert. Updates all rows flagged for update if the entries exist in the target. If the entries do not exist, the PowerCenter Integration Service inserts the entries.
Pre-SQL	The pre-SQL commands to run before the PowerCenter Integration Service writes data to the target.
Post-SQL	The post-SQL commands to run after the PowerCenter Integration Service writes data to the target.
Truncate Target	The PowerCenter Integration Service truncates the target before writing the data.