PostgreSQL bulk loader
DescriptionThe PostgreSQL bulk loader transform streams data from Hop to Postgresql using "COPY DATA FROM STDIN" into the database.
COPY error messages rarely name the stream field and value. Put Database value validation in front of this transform to catch over-long strings, encoding problems, numeric overflow and invalid UUID/JSON before COPY runs. |
| The PostgreSQL bulk loader is linked to the database type. It will fetch the JDBC driver from the hop/lib/jdbc folder. Valid locations for the JDBC driver for this transform are the database plugin lib and the main hop/lib folder. It will not work in combination with the SHARED_JDBC_FOLDER variable. |
Options
| Option | Description |
|---|---|
Transform name | Name of the transform. |
Connection | Name of the database connection on which the target table resides. |
Target schema | The name of the Schema for the table to write data to. This is important for data sources that allow for table names with dots '.' in it. |
Target table | Name of the target table. |
Load action | Insert, Truncate. Insert inserts, truncate first truncates the table. |
DB Name Override | (optional) database name to override the database name used in this transform’s connection. |
Enclosure | the enclosure character to use in the |
Delimiter | the delimiter character to use in the |
Stop on error | Stop the execution of this transform when an error occurs |
Fields to load | This table contains a list of fields to load data from, properties include:
|