The PostgreSQL Wiki
Every PostgreSQL object, in every version that documented it.
Explore the commands, functions, parameters, catalogs, and signals that make PostgreSQL work. English manual definitions, connected to their history and operational context.
4765 reference entries · 30 collections · PostgreSQL 6.3 – 20
Query language
SQL Commands
Syntax, examples, and the evolution of every PostgreSQL SQL command.
Data Types
Data types, aliases, storage, operators and versioned definitions.
Functions
Built-in function signatures, examples, and changes across major versions.
Operators
Operator overloads with operand and result types, implementation functions and index membership.
SQLSTATE
Error conditions, diagnostic context, and version-specific definitions.
Indexes and storage
System Catalogs
Catalogs and views, their columns, and how their structures change.
Index AM
Index capabilities, query patterns, limits and storage options.
Table AM
Table access methods, tuple organization, MVCC, maintenance and implementation boundaries.
Operator Families
Index operator classes and families, strategy operators and support functions.
Storage Parameters
Table and index storage options from each version’s manual.
Storage Structures
Database files, relation forks, pages, tuples, TOAST, free-space and visibility maps.
OID Types
OID alias types, input forms, and object lookup behavior.
Operations
GUC Parameters
Configuration parameters, documented behavior, and measured default history.
Plan Nodes
Execution plan nodes, source interfaces, strategies, resource behavior and examples.
Wait Events
What PostgreSQL is waiting for, with definitions and diagnostic context.
Locks
Table and row locks, conflicts, and the commands that acquire them.
Statistics & Metrics
Individually addressable statistics and progress fields, definitions, units and reset context.
Authentication Methods
Client authentication methods, configuration, requirements and version-specific behavior.
Predefined Roles
Built-in roles and their version-specific privileges.
Client tools
psql Commands
Backslash commands with exact syntax, modifiers, examples and client-version history.
Command-line Tools
Client and server programs, command options, environment variables and operational examples.
Connection Parameters
libpq connection keywords, environment mappings, defaults and precedence by client version.
Protocol Messages
Frontend/backend message directions, wire fields and same-version protocol definitions.
Extensibility
Foreign Data Wrappers
External data adapters, versioned capabilities, transaction behavior and extension evidence.
Hooks
Core extension points, signatures, and versioned source definitions.
Procedural Languages
Core procedural languages, handlers, trust boundaries and versioned programming interfaces.
Text Search Components
Text search parsers, dictionaries, templates and configurations with source identities.
Collations & Encodings
Server encodings and collation providers with explicit locale and build-dependent boundaries.
Logical Decoding Plugins
Logical decoding output plugins, formats, options and implementation-specific evidence.
Releases
Start with a question.
Find work_mem, inspect pg_class, understand a deadlock, or explore the syntax of MERGE. Every entry links back to the manual for the version you select.