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
SPI_connect
SPI_finish
SPI_exec
SPI_prepare
SPI_saveplan
SPI_execp
Interface Support Functions
SPI_copytuple
SPI_modifytuple
SPI_fnumber
SPI_fname
SPI_getvalue
SPI_getbinval
SPI_gettype
SPI_gettypeid
SPI_getrelname
SPI_palloc
SPI_repalloc
SPI_pfree
Memory Management
Visibility of Data Changes
Examples
13. Functions
14. Large Objects
Historical Note
Inversion Large Objects
Large Object Interfaces
Creating a Large Object
Importing a Large Object
Exporting a Large Object
Opening an Existing Large Object
Writing Data to a Large Object
Seeking on a Large Object
Closing a Large Object Descriptor
Built in registered functions
Accessing Large Objects from LIBPQ
Sample Program
15. ecpg - Embedded SQL in C
Why Embedded SQL?
The Concept
How To Use egpc
Preprocessor
Library
Error handling
Limitations
Porting From Other RDBMS Packages
Installation
For the Developer
ToDo List
The Preprocessor
A Complete Example
The Library
16. libpq
Control and Initialization
Database Connection Functions
Query Execution Functions
Fast Path
Asynchronous Notification
Functions Associated with the COPY Command
libpq Tracing Functions
User Authentication Functions
BUGS
Sample Programs
Sample Program 1
Sample Program 2
Sample Program 3
17. pgtcl
Commands
Examples
Reference Information
pg_connect
pg_disconnect
pg_exec
pg_select
pg_result
pg_lo_creat
pg_lo_open
pg_lo_close
pg_lo_read
pg_lo_write
pg_lo_lseek
pg_lo_tell
pg_lo_unlink
pg_lo_import
pg_lo_export
18. ODBC Interface
Background
19. JDBC Interface
20. Architecture
Postgres Architectural Concepts
21. Genetic Query Optimization in Database Systems
22. Frontend/Backend Protocol
Overview
Protocol
Authentication
Query
Function Call
Termination
Message Data Types
Message Formats
23. GCC Default Optimizations
A. Documentation
Introduction
Styles and Conventions
Building Documentation
Toolsets
jade
Modular Style Sheets
Hardcopy Generation for v6.3
RTF Cleanup Procedure
Alternate Toolsets
sgml-tools
sgml2latex
latex
SQL References

  Next
  Summary