Skip to main content

PostgreSQL components

tPostgresqlBulkExec Improves performance while carrying out the Insert operations to a Postgresql database.
tPostgresqlClose Closes the transaction committed in the connected Postgresql database.
tPostgresqlCommit Commits in one go a global transaction, using a unique connection, instead of doing that on every row or every batch and thus improves performance.
tPostgresqlConnection Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.
tPostgresqlInput Executes a DB query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component via a Main row link.
tPostgresqlInvalidRows Extracts DB rows that do not match a given data quality pattern, you can then implement any required correction.
tPostgresqlOutput Executes the action defined on the table and/or on the data contained in the table, based on the flow incoming from the preceding component in the job.
tPostgresqlOutputBulk Prepares the file to be used as parameters in the INSERT query to feed the Postgresql database.
tPostgresqlOutputBulkExec Improves performance during Insert operations to a Postgresql database.
tPostgresqlRollback Avoids to commit part of a transaction involuntarily.
tPostgresqlRow Acts on the actual DB structure or on the data (although without handling data), depending on the nature of the query and the database. The SQLBuilder tool helps you write easily your SQL statements.
tPostgresqlValidRows Extracts DB rows that match a given data quality pattern.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!