---
title: "PostgreSQL Data Source Template"
slug: "postgresql-data-source-template"
updated: 2026-04-08T18:49:02Z
published: 2026-04-08T18:49:02Z
canonical: "docs.validatar.com/postgresql-data-source-template"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.validatar.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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

## Related Articles

- [What Is a Data Source Template?](/docs/what-is-a-data-source-template-overview)
- [Metadata Ingestion Scripts — SQL Templates](/docs/metadata-ingestion-scripts-sql-templates)
- [Profiling Configuration — SQL Templates](/docs/profiling-configuration-sql-templates)