September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 7.3 / 7.2 / 7.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

I. Client Interfaces

Table of Contents
1. libpq - C Library
1.1. Database Connection Functions
1.2. Query Execution Functions
1.3. Asynchronous Query Processing
1.4. Fast Path
1.5. Asynchronous Notification
1.6. Functions Associated with the COPY Command
1.7. libpq Tracing Functions
1.8. libpq Control Functions
1.9. Environment Variables
1.10. Threading Behavior
1.11. Example Programs
2. Large Objects
2.1. Historical Note
2.2. Implementation Features
2.3. Interfaces
2.4. Built in registered functions
2.5. Accessing Large Objects from LIBPQ
2.6. Sample Program
3. libpq++ - C++ Binding Library
3.1. Control and Initialization
3.2. libpq++ Classes
3.3. Database Connection Functions
3.4. Query Execution Functions
3.5. Asynchronous Notification
3.6. Functions Associated with the COPY Command
4. pgtcl - TCL Binding Library
4.1. Commands
4.2. Examples
4.3. pgtcl Command Reference Information
5. libpgeasy - Simplified C Library
6. ecpg - Embedded SQL in C
6.1. Why Embedded SQL?
6.2. The Concept
6.3. How To Use ecpg
6.4. Limitations
6.5. Porting From Other RDBMS Packages
6.6. For the Developer
7. ODBC Interface
7.1. Background
7.2. Installation
7.3. Configuration Files
7.4. Windows Applications
7.5. ApplixWare
8. JDBC Interface
8.1. Setting up the JDBC Driver
8.2. Using the Driver
8.3. Issuing a Query and Processing the Result
8.4. Performing Updates
8.5. Using Large Objects
8.6. PostgreSQL Extensions to the JDBC API
8.7. Using the driver in a multi-threaded or a servlet environment
8.8. Further Reading
9. PyGreSQL - Python Interface
9.1. The pg Module
9.2. pg Module Functions
9.3. Connection object: pgobject
9.4. Database wrapper class: DB
9.5. Query result object: pgqueryobject
9.6. Large Object: pglarge
9.7. DB-API Interface
10. Lisp Programming Interface