tELTPostgresqlOutput
Performs the action (insert, update or delete) on data in the specified
Postgresql table through the SQL statement generated by the
tELTPostgresqlMap component.
The three ELT Postgresql components are closely
related, in terms of their operating conditions. These components should be used to
handle Postgresql database table schemas to generate SQL statements, including clauses,
which are to be executed in the database output table defined.
tELTPostgresqlOutput Standard properties
These properties are used to configure tELTPostgresqlOutput running in the Standard Job framework.
The Standard
tELTPostgresqlOutput component belongs to the ELT family.
The component in this framework is available in all Talend
products.
Basic settings
Action on data |
On the data of the table defined, you can
Insert: Add new entries
Update: Updates entries
Delete: Deletes the |
Schema and Edit schema |
A schema is a row description, that is to say, Click Edit
|
 |
Built-in: The schema is |
 |
Repository: The schema |
Where clauses for (for UPDATE and |
Enter a clause to filter the data to be updated |
Default Table Name |
Enter the default table name between double |
Default Schema Name |
Enter the default schema name between double |
Table name from connection name is |
Select this check box when the name of the connection to this |
Use different table name |
Select this check box to enter a different |
Mapping |
Specify the metadata mapping file |
Advanced settings
Use update statement without subqueries |
Select this option to generate an UPDATE statement for the This option is available when Update is selected from the |
tStatCatcher Statistics |
Select this check box to gather the Job |
Global Variables
Global Variables |
NB_LINE: the number of rows read by an input component or
NB_LINE_INSERTED: the number of rows inserted. This is an
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
tELTPostgresqlOutput is Note:
Note that the ELT components do not handle |