You can't use this until you register with us!




Description

Update data in one PostgreSQL database table from another.


Purchasing Options



Available Actions

Replicate Table

Use data from one table to insert and update records in another.


Variables

Source Parameters
source_db required

Postgres Database containing the table with data to replicate.

source_schema required

Schema of the table with data to replicate.

source_table required

Name of the table with data to replicate.


Target Parameters
target_db required

Postgres Database containing the table to update.

target_schema required

Schema of the table to update.

target_table required

Name of the table to update.


Replication Parameters
sync_column required

Name of the sorted column in both tables containing unique integer or date values to use as row identifiers for updates.

range_start_point

Only rows with a value in the Unique Column that is greater than this value will be replicated. Leave blank to use the last row of the Target Table as the starting point. This value is NOT automatically updated during Task execution.