Integrations

Generic JDBC - Postgresql

Support

Support from 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 that contains the tables being governed, and SELECT permission on each table for which metadata extraction and data sampling is to be performed.

Metadata extraction

Tables with 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.