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

This part of the manual is the description of the client-side programming interfaces and support libraries for various languages.

Table of Contents
1. libpq - C Library
1.1. Introduction
1.2. Database Connection Functions
1.3. Command Execution Functions
1.4. Asynchronous Query Processing
1.5. The Fast-Path Interface
1.6. Asynchronous Notification
1.7. Functions Associated with the COPY Command
1.8. libpq Tracing Functions
1.9. libpq Control Functions
1.10. Environment Variables
1.11. Threading Behavior
1.12. Building Libpq Programs
1.13. Example Programs
2. Large Objects
2.1. Introduction
2.2. Implementation Features
2.3. Interfaces
2.4. Server-side Built-in Functions
2.5. Accessing Large Objects from Libpq
3. libpq++ - C++ Binding Library
3.1. Introduction
3.2. Control and Initialization
3.3. libpq++ Classes
3.4. Database Connection Functions
3.5. Query Execution Functions
3.6. Asynchronous Notification
3.7. Functions Associated with the COPY Command
4. pgtcl - Tcl Binding Library
4.1. Introduction
4.2. Loading pgtcl into your application
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. Introduction
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. Creating and Modifying Database Objects
8.6. Storing Binary Data
8.7. PostgreSQL Extensions to the JDBC API
8.8. Using the driver in a multi-threaded or a servlet environment
8.9. 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