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 for to translate.
...
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 the software and no additional preparations are required.