This section contains information that is specific to the database type PostgreSQL.

Supported Functions

The PostgreSQL database can be used with:

• Audit Profile

• Callable Statements (APL)

• Database Bulk Lookup Functions (APL)

• Database Table Related Functions (APL)

• Database Collection/Forwarding Agents

• Data Masking Profile

• Event Notifications

• Prepared Statements (APL)

• Reference Data Management

• Shared Table Profile

• SQL Collection/Forwarding Agents

• SQL Loader Agent

• Task Workflows Agents (SQL)

Supported Types

PostgreSQL has many specialized types that may be difficult to translate.

The following data types have been verified to perform well with Shared Tables, and other database functions:

• smallint

• integer

• bigint

• numeric

• double precision

• smallserial

• serial

• bigserial

• char(n) 

• varchar(n)

• timestamp with time zone

• timestamp without time zone

• date

• time with time zone

• time without time zone

Support of data types that are not listed above cannot be guaranteed.

Properties

When selecting the PostgreSQL database type, you can configure the following property using the Properties tab in the Database profile:

postgresql.connectionpool.maxlimit

Preparations

The drivers that are required to use the PostgreSQL database are bundled with the software and no additional preparations are required.