PostgreSQL(3.0)
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.