PostgreSQL Bulk Loader

    OptionDescription

    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

    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 part of the copy command

    Delimiter

    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:

    • Stream field: Field to be taken from the incoming rows;