Documentation → PostgreSQL 8.2

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 8.2.23 Documentation
Prev	Fast Backward		Fast Forward	Next

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.

Prev	Home	Next
Example Program	Up	The Concept