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 ( ) and Michael Meskes ( ). 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.