Chapter 33. ECPG - Embedded SQL in C
- Table of Contents
- 33.1. The Concept
- 33.2. Connecting to the Database Server
- 33.3. Closing a Connection
- 33.4. Running SQL Commands
- 33.5. Choosing a Connection
- 33.6. Using Host Variables
- 33.6.1. Overview
- 33.6.2. Declare Sections
- 33.6.3. Different types of host variables
- 33.6.4.
SELECT INTO and FETCH INTO
- 33.6.5. Indicators
- 33.7. Dynamic SQL
- 33.8. pgtypes library
- 33.8.1. The numeric type
- 33.8.2. The date type
- 33.8.3. The timestamp type
- 33.8.4. The interval type
- 33.8.5. The decimal type
- 33.8.6. errno values of pgtypeslib
- 33.8.7. Special constants of pgtypeslib
- 33.9. Using Descriptor Areas
- 33.9.1. Named SQL Descriptor Areas
- 33.9.2. SQLDA Descriptor Areas
- 33.10.
Informix compatibility mode
- 33.10.1. Additional types
- 33.10.2. Additional/missing embedded SQL statements
- 33.10.3. Informix-compatible SQLDA Descriptor Areas
- 33.10.4. Additional functions
- 33.10.5. Additional constants
- 33.11. Error Handling
- 33.11.1. Setting Callbacks
- 33.11.2. sqlca
- 33.11.3.
SQLSTATE vs SQLCODE
- 33.12. Preprocessor directives
- 33.12.1. Including files
- 33.12.2. The #define and #undef directives
- 33.12.3. ifdef, ifndef, else, elif, and endif directives
- 33.13. Processing Embedded SQL Programs
- 33.14. Library Functions
- 33.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.