# PostgreSQL components

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