PostgreSQL Programmer's Guide

Covering v6.3 for general release

by The PostgreSQL Development Team

Edited by Thomas Lockhart

(last updated 1998-02-24)

PostgreSQL is copyright (C) 1998 by the Postgres Global Development Group.

Table of Contents
Summary
1. Introduction
Copyrights and Trademarks
2. Architecture
Postgres Architectural Concepts
3. Extending SQL: An Overview
How Extensibility Works
The Postgres Type System
About the Postgres System Catalogs
4. Extending SQL: Functions
Query Language (SQL) Functions
SQL Functions on Base Types
SQL Functions on Composite Types
Programming Language Functions
Programming Language Functions on Base Types
Programming Language Functions on Composite Types
Caveats
5. Extending SQL: Types
User-Defined Types
Functions Needed for a User-Defined Type
Large Objects
6. Extending SQL: Operators
7. Extending SQL: Aggregates
8. Interfacing Extensions To Indices
9. GiST Indices
10. Linking Dynamically-Loaded Functions
ULTRIX
DEC OSF/1
SunOS 4.x, Solaris 2.x and HP-UX
11. Triggers
Trigger Creation
Interaction with the Trigger Manager
Visibility of Data Changes
Examples
12. Server Programming Interface
Interface Functions