RDBMS providers: PostgreSQL

Connects to PostgreSQL database servers.

• PostgreSQL, JDBC (jdbc): this driver is slower than the ODBC driver. It requires the JDBC driver JARr for PostgreSQL, available from the PostgreSQL web site.

• PostgreSQL, JDBC, Bulk-loader (jdbc): use this driver for high-volume inserts into the PostgreSQL database; it is faster at inserting rows than the ODBC driver. However, on all other types of operations it has the same characteristics as the JDBC driver listed above. This driver requires the JDBC driver JAR for PostgreSQL, available from the PostgreSQL web site.

• PostgreSQL, ODBC Native x64 (odbc native): this method can be used to access either Postgres or Greenplum databases, although load speeds will be slower on Greenplum than the Gpfdist driver. Requires installation of ODBC drivers available from PostgreSQL web site.
  The default settings for PostgreSQL ODBC Native x64 specify TextAsLongVarchar=yes and B1=8190. This means that if a CREATE TABLE statement is issued using this data connection, any columns of type TEXT will be re-interpreted as VARCHAR(8190), and values written to those columns will be truncated to 8190 characters if necessary. Since the TEXT type normally has no meaningful limit on the number of characters, this behavior may be undesirable. To turn off this option or change the size limit, edit the values of TextAsLongVarchar and B1 in a data connection. Note that the JDBC provider does not process the TextAsLongVarchar or the B1 parameters, so it will not exhibit this behavior.

• PostgreSQL, ODBC Native (odbc native): standard connection method. Requires installation of ODBC drivers available from PostgreSQL web site.

ODBC providers have been deprecated in Data Management, and the ODBC drivers may not be supported in future versions.

Internal deadlocks occur if multiple PostgreSQL bulk loaders try to run within a single project. Therefore, a project can only include one PostgreSQL bulk loader tool. If you need to run multiple bulk loads as a unit, you must use automation to connect several individual loads.