Historical version. PostgreSQL 8.2 has reached end of support. See the current manual.
Chapter 31. ECPG - Embedded SQL in C
- Table of Contents
- 31.1. The Concept
- 31.2. Connecting to the Database Server
- 31.3. Closing a Connection
- 31.4. Running SQL Commands
- 31.5. Choosing a Connection
- 31.6. Using Host Variables
- 31.6.1. Overview
- 31.6.2. Declare Sections
- 31.6.3. Different types of host variables
- 31.6.4. SELECT INTO and FETCH INTO
- 31.6.5. Indicators
- 31.7. Dynamic SQL
- 31.8. pgtypes library
- 31.8.1. The numeric type
- 31.8.2. The date type
- 31.8.3. The timestamp type
- 31.8.4. The interval type
- 31.8.5. The decimal type
- 31.8.6. errno values of pgtypeslib
- 31.8.7. Special constants of pgtypeslib
- 31.9. Informix compatibility mode
- 31.9.1. Additional embedded SQL statements
- 31.9.2. Additional functions
- 31.9.3. Additional constants
- 31.10. Using SQL Descriptor Areas
- 31.11. Error Handling
- 31.11.1. Setting Callbacks
- 31.11.2. sqlca
- 31.11.3. SQLSTATE vs SQLCODE
- 31.12. Preprocessor directives
- 31.12.1. Including files
- 31.12.2. The #define and #undef directives
- 31.12.3. ifdef, ifndef, else, elif and endif directives
- 31.13. Processing Embedded SQL Programs
- 31.14. Library Functions
- 31.15. Internals
This chapter describes the embedded SQL package
for PostgreSQL. It was written by
Linus Tolke (<linus@epact.se>) and Michael Meskes
(<meskes@postgresql.org>). Originally it was written to work with
C. It also works with C++, but
it does not recognize all C++ constructs yet.
This documentation is quite incomplete. But since this interface is standardized, additional information can be found in many resources about SQL.
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.