PostgreSQL 16.0 Documentation

The PostgreSQL Global Development Group

Copyright © 1996–2023 The PostgreSQL Global Development Group

Legal Notice

Table of Contents

• Preface

  • 1. What Is PostgreSQL?
  • 2. A Brief History of PostgreSQL
  • 3. Conventions
  • 4. Further Information
  • 5. Bug Reporting Guidelines

• I. Tutorial

  • 1. Getting Started
  • 2. The SQL Language
  • 3. Advanced Features

• II. The SQL Language

  • 4. SQL Syntax
  • 5. Data Definition
  • 6. Data Manipulation
  • 7. Queries
  • 8. Data Types
  • 9. Functions and Operators
  • 10. Type Conversion
  • 11. Indexes
  • 12. Full Text Search
  • 13. Concurrency Control
  • 14. Performance Tips
  • 15. Parallel Query

• III. Server Administration

  • 16. Installation from Binaries
  • 17. Installation from Source Code
  • 18. Installation from Source Code on Windows
  • 19. Server Setup and Operation
  • 20. Server Configuration
  • 21. Client Authentication
  • 22. Database Roles
  • 23. Managing Databases
  • 24. Localization
  • 25. Routine Database Maintenance Tasks
  • 26. Backup and Restore
  • 27. High Availability, Load Balancing, and Replication
  • 28. Monitoring Database Activity
  • 29. Monitoring Disk Usage
  • 30. Reliability and the Write-Ahead Log
  • 31. Logical Replication
  • 32. Just-in-Time Compilation (JIT)
  • 33. Regression Tests

• IV. Client Interfaces

  • 34. libpq — C Library
  • 35. Large Objects
  • 36. ECPG — Embedded SQL in C
  • 37. The Information Schema

• V. Server Programming

  • 38. Extending SQL
  • 39. Triggers
  • 40. Event Triggers
  • 41. The Rule System
  • 42. Procedural Languages
  • 43. PL/pgSQL — SQL Procedural Language
  • 44. PL/Tcl — Tcl Procedural Language
  • 45. PL/Perl — Perl Procedural Language
  • 46. PL/Python — Python Procedural Language
  • 47. Server Programming Interface
  • 48. Background Worker Processes
  • 49. Logical Decoding
  • 50. Replication Progress Tracking
  • 51. Archive Modules

• VI. Reference

  • I. SQL Commands
  • II. PostgreSQL Client Applications
  • III. PostgreSQL Server Applications

• VII. Internals

  • 52. Overview of PostgreSQL Internals
  • 53. System Catalogs
  • 54. System Views
  • 55. Frontend/Backend Protocol
  • 56. PostgreSQL Coding Conventions
  • 57. Native Language Support
  • 58. Writing a Procedural Language Handler
  • 59. Writing a Foreign Data Wrapper
  • 60. Writing a Table Sampling Method
  • 61. Writing a Custom Scan Provider
  • 62. Genetic Query Optimizer
  • 63. Table Access Method Interface Definition
  • 64. Index Access Method Interface Definition
  • 65. Generic WAL Records
  • 66. Custom WAL Resource Managers
  • 67. B-Tree Indexes
  • 68. GiST Indexes
  • 69. SP-GiST Indexes
  • 70. GIN Indexes
  • 71. BRIN Indexes
  • 72. Hash Indexes
  • 73. Database Physical Storage
  • 74. Transaction Processing
  • 75. System Catalog Declarations and Initial Contents
  • 76. How the Planner Uses Statistics
  • 77. Backup Manifest Format

• VIII. Appendixes

  • A. PostgreSQL Error Codes
  • B. Date/Time Support
  • C. SQL Key Words
  • D. SQL Conformance
  • E. Release Notes
  • F. Additional Supplied Modules and Extensions
  • G. Additional Supplied Programs
  • H. External Projects
  • I. The Source Code Repository
  • J. Documentation
  • K. PostgreSQL Limits
  • L. Acronyms
  • M. Glossary
  • N. Color Support
  • O. syncfs() Caveats
  • P. Obsolete or Renamed Features

• Bibliography

• Index