November 14, 2024: PostgreSQL 17.1, 16.5, 15.9, 14.14, 13.17, and 12.21 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 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.
PostgreSQL 9.0.23 Documentation
Prev Up Next

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 () 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.

Prev Home Next
Example Program Up The Concept