Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

PostgreSQL

Versions. CI tests datarig against PostgreSQL 17. Not supported before PostgreSQL 12: a table’s structure, its DDL, the key marks and copying rows as INSERT (datarig says the server is too old).

A PostgreSQL profile has driver = "postgres", and a URL starts with postgres://, for example postgres://me@db.internal:5432/app?sslmode=verify-full (Connections).

This page gathers what the rest of the guide says about PostgreSQL.

Connecting

Safety

  • Every statement is parsed with PostgreSQL’s own parser before it is sent, and statements that may do harm ask first (Environments and safety).
  • A read-only profile refuses writes before anything is sent, and the server enforces it too.
  • Manual commit keeps your changes in a transaction until you commit or roll it back; Startup SQL sets what each session starts with.

Working with data

Something missing or wrong? See the FAQ, or open an issue on GitHub.