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

Supported Functions

The PostgreSQL database can be used with:

• Audit Profile
• Database Table Related Functions (APL)
• Database Collection/Forwarding Agents
• Event Notifications

Supported Types

PostgreSQL has many specialized types that may be difficult for 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.