PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Documentation → PostgreSQL 7.1

Unsupported versions: 7.3 / 7.2 / 7.1

Historical version. PostgreSQL 7.1 has reached end of support. See the current manual.

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

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.