Integrations
Breadcrumbs

Generic JDBC - PostgreSQL

Support

Support from version 8.2 up to version 13.

Configuration

Vendor

POSTGRESQL

Connection format

The connection URL format is jdbc:postgresql://<database_host>:<port>/database=<database>

Permissions

User or role with USAGE permissions on the schema containing the governed tables and SELECT permission on each table for which metadata extraction and data sampling are desired.

Metadata extraction

Tables with special characters in the name

This technology allows characters such as “/” in the name; if they are being used, the path-separator must be configured with a character other than “/”. See File extraction for more details.