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 Source Code

17. Installation from Source Code on Windows

18. Server Setup and Operation

19. Server Configuration

20. Client Authentication

21. Database Roles

22. Managing Databases

23. Localization

24. Routine Database Maintenance Tasks

25. Backup and Restore

26. High Availability, Load Balancing, and Replication

27. Recovery Configuration

28. Monitoring Database Activity

29. Monitoring Disk Usage

30. Reliability and the Write-Ahead Log

31. Logical Replication

32. Regression Tests

IV. Client Interfaces

33. libpq - C Library

34. Large Objects

35. ECPG - Embedded SQL in C

36. The Information Schema

V. Server Programming

37. Extending SQL

38. Triggers

39. Event Triggers

40. The Rule System

41. Procedural Languages

42. PL/pgSQL - SQL Procedural Language

43. PL/Tcl - Tcl Procedural Language

44. PL/Perl - Perl Procedural Language

45. PL/Python - Python Procedural Language

46. Server Programming Interface

47. Background Worker Processes

48. Logical Decoding

49. Replication Progress Tracking

VI. Reference

I. SQL Commands

II. PostgreSQL Client Applications

III. PostgreSQL Server Applications

VII. Internals

50. Overview of PostgreSQL Internals

51. System Catalogs

52. Frontend/Backend Protocol

53. PostgreSQL Coding Conventions

54. Native Language Support

55. Writing A Procedural Language Handler

56. Writing A Foreign Data Wrapper

57. Writing A Table Sampling Method

58. Writing A Custom Scan Provider

59. Genetic Query Optimizer

60. Index Access Method Interface Definition

61. Generic WAL Records

62. GiST Indexes

63. SP-GiST Indexes

64. GIN Indexes

65. BRIN Indexes

66. Hash Indexes

67. Database Physical Storage

68. BKI Backend Interface

69. How the Planner Uses Statistics

VIII. Appendixes

A. PostgreSQL Error Codes

B. Date/Time Support

C. SQL Key Words

D. SQL Conformance

E. Release Notes

F. Additional Supplied Modules

G. Additional Supplied Programs

H. External Projects

I. The Source Code Repository

J. Documentation

K. Acronyms

L. Obsolete or Renamed Features

Bibliography

Index