Element Details: PostgreSQL+Custom+Bulk+Command
 Back


Available in: Logi Info Source code name: PostgreSQLCustomBulkCommand

Normally you will not need to use this element since ETL automatically generates a PostgreSQL bulk insert command based on the information provided by the LoadDbTable.Insert element.

Use this element to replace the automatically generated command with your custom bulk insert command. The custom command provided will be passed to the PostgreSQL data provider for processing.

This element is only used if the LoadDbTable.Insert attribute Insert Method is set to bulk.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
CustomPostgreSqlBulkCommand
UserDefined
(Required) The custom PostgreSQL bulk load command to use. In addition to the standard Logi tokens, the following custom tokens are also available. The values for these tokens are automatically defined based on the attribute values of your LoadDbTable.Insert element. @Etl.BulkTableName~ = Table name to insert into. @Etl.BulkFieldDelimiter~ = Field delimiter. @Etl.BulkTextQualifier~ = Text qualifier. @Etl.BulkRowDelimiter~ = Row delimiter. Sample PostgreSQL bulk load command: COPY @Etl.BulkTableName~ (field1, field2, etc) FROM STDIN WITH DELIMITER AS '@Etl.BulkFieldDelimiter~' CSV
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.



PARENT ELEMENTS

Click element to drill down for more information.

Load DB Table.Insert


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top