This PostgreSQL Manual can be downloaded in pdf and html formats. This book is the official documentation of PostgreSQL. It has been written by the PostgreSQL developers and other volunteers in parallel to the development of the PostgreSQL software. It describes all the functionality that the current version of PostgreSQL officially supports.
Book Description
To make the large amount of information about PostgreSQL manageable, this book has been organized in several parts. Each part is targeted at a different class of users, or at users in different stages of their PostgreSQL experience. It is divided into following sections: Tutorial, The SQL Language, Server Administration, Client Interfaces, Server Programming, Reference, Internals and Appendixes.
Table of Contents
- Getting Started
- The SQL Language
- Advanced Features
- SQL Syntax
- Data Definition
- Data Manipulation
- Queries
- Data Types
- Functions and Operators
- Type Conversion
- Indexes
- Full Text Search
- Concurrency Control
- Performance Tips
- Installation from Source Code
- Installation from Source Code on Windows
- Server Setup and Operation
- Server Configuration
- Client Authentication
- Database Roles and Privileges
- Managing Databases
- Localization
- Routine Database Maintenance Tasks
- Backup and Restore
- High Availability, Load Balancing, and Replication
- Recovery Configuration
- Monitoring Database Activity
- Monitoring Disk Usage
- Reliability and the Write-Ahead Log
- Regression Tests
- libpq – C Library
- Large Objects
- ECPG – Embedded SQL in C
- The Information Schema
- Extending SQL
- Triggers
- The Rule System
- Procedural Languages
- PL/pgSQL – SQL Procedural Language
- PL/Tcl – Tcl Procedural Language
- PL/Perl – Perl Procedural Language
- PL/Python – Python Procedural Language
- Server Programming Interface
- Overview of PostgreSQL Internals
- System Catalogs
- Frontend/Backend Protocol
- PostgreSQL Coding Conventions
- Native Language Support
- Writing A Procedural Language Handler
- Genetic Query Optimizer
- Index Access Method Interface Definition
- GiST Indexes
- GIN Indexes
- Database Physical Storage
- BKI Backend Interface
- How the Planner Uses Statistics