PostgreSQL Data Source Template

Overview

The PostgreSQL data source template is a built-in SQL template for PostgreSQL database connections. It provides metadata ingestion scripts that query PostgreSQL's information_schema and pg_catalog views, data type mappings including PostgreSQL-specific types, and standard profiling definitions.

Platform: PostgreSQL (12+)
Connection Category: Database
Template Category: Built-in

What's Included

Connection Configuration

Supports PostgreSQL native and ODBC connections
Identifier delimiters: " / "

Data Type Mappings

Includes mappings for PostgreSQL data types including aliases:

String types: varchar, character varying, text, char, character
Numeric types: integer, int4, bigint, int8, smallint, int2, serial, bigserial, numeric, decimal, real, float4, double precision, float8
Date/time types: date, timestamp, timestamp without time zone, timestamp with time zone, timestamptz, time, time without time zone, time with time zone
Boolean: boolean, bool
Binary: bytea
Other: json, jsonb, xml, uuid, inet, cidr, macaddr, point, line, polygon

Metadata Ingestion

Schema Level

Queries information_schema.schemata, excluding pg_* system schemas and information_schema.

Table Level

Queries information_schema.tables to discover tables and views.

Column Level

Queries information_schema.columns to discover columns with data types, nullability, and character/numeric precision.

Profiling

Includes the standard set of ~40 profile definitions using PostgreSQL-compatible SQL expressions.

Installation

The PostgreSQL template ships with Validatar — no import required.

Customization

Common customizations:

Search path — Add a pre-execution script to set search_path for your environment
Schema filters — Include only application schemas, exclude extension schemas
Custom types — Add data type mappings for domain-specific custom types
Partitioned tables — Adjust ingestion to handle PostgreSQL's native partitioning