↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.3 / 7.2 / 7.1
Historical version. PostgreSQL 7.2 reached end of support in February 2007. See the current manual for supported releases.
PostgreSQL 7.2.8 Documentation
Prev Next

II. Server Programming

This second part of the manual explains the PostgreSQL approach to extensibility and describe how users can extend PostgreSQL by adding user-defined types, operators, aggregates, and both query language and programming language functions. After a discussion of the PostgreSQL rule system, we discuss the trigger and SPI interfaces.

Table of Contents
10. Architecture
10.1. PostgreSQL Architectural Concepts
11. Extending SQL: An Overview
11.1. How Extensibility Works
11.2. The PostgreSQL Type System
11.3. About the PostgreSQL System Catalogs
12. Extending SQL: Functions
12.1. Introduction
12.2. Query Language (SQL) Functions
12.3. Procedural Language Functions
12.4. Internal Functions
12.5. C Language Functions
12.6. Function Overloading
12.7. Procedural Language Handlers
13. Extending SQL: Types
14. Extending SQL: Operators
14.1. Introduction
14.2. Example
14.3. Operator Optimization Information
15. Extending SQL: Aggregates
16. The Rule System
16.1. Introduction
16.2. What is a Query Tree?
16.3. Views and the Rule System
16.4. Rules on INSERT, UPDATE and DELETE
16.5. Rules and Permissions
16.6. Rules versus Triggers
17. Interfacing Extensions To Indexes
17.1. Introduction
17.2. Access Methods
17.3. Access Method Strategies
17.4. Access Method Support Routines
17.5. Operator Classes
17.6. Creating the Operators and Support Routines
18. Index Cost Estimation Functions
19. GiST Indexes
20. Triggers
20.1. Trigger Creation
20.2. Interaction with the Trigger Manager
20.3. Visibility of Data Changes
20.4. Examples
21. Server Programming Interface
21.1. Interface Functions
21.2. Interface Support Functions
21.3. Memory Management
21.4. Visibility of Data Changes
21.5. Examples
Prev Home Next
DB-API Interface Up Architecture

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.