# PostgreSQL 7.3.4 Programmer's Guide

### The PostgreSQL Global Development Group

Copyright © 1996-2002 The PostgreSQL Global Development Group

List of Tables
3-1. pgtcl Commands
5-1. ConnectionPoolDataSource Implementations
5-2. ConnectionPoolDataSource Configuration Properties
5-3. DataSource Implementations
5-4. DataSource Configuration Properties
5-5. Additional Pooling DataSource Configuration Properties
8-1. PostgreSQL System Catalogs
9-1. Equivalent C Types for Built-In PostgreSQL Types
14-1. B-tree Strategies
14-2. Hash Strategies
14-3. R-tree Strategies
14-4. B-tree Support Functions
14-5. Hash Support Functions
14-6. R-tree Support Functions
14-7. GiST Support Functions
19-1. Single Quotes Escaping Chart

List of Figures
7-1. How a connection is established
8-1. The major PostgreSQL system catalogs

List of Examples
1-1. libpq Example Program 1
1-2. libpq Example Program 2
1-3. libpq Example Program 3
2-1. Large Objects with Libpq Example Program
3-1. pgtcl Example Program
5-1. Processing a Simple Query in JDBC
5-2. Simple Delete Example
5-3. Drop Table Example
5-4. Binary Data Examples
5-5. ConnectionPoolDataSource Configuration Example
5-6. DataSource Code Example
5-7. DataSource JNDI Code Example
18-1. Manual Installation of PL/pgSQL
19-1. A PL/pgSQL Trigger Procedure Example
19-2. A Simple PL/pgSQL Function to Increment an Integer
19-3. A Simple PL/pgSQL Function to Concatenate Text
19-4. A PL/pgSQL Function on Composite Type
19-5. A Simple Function
19-6. A Function that Creates Another Function
19-7. A Procedure with a lot of String Manipulation and OUT Parameters

Prev | Home | Next
Postgres95 Release 0.01 |  | Preface