Chapter 39. ECPG — Embedded SQL in C
Table of Contents
- 39.1. The Concept
- 39.2. Managing Database Connections
- 39.3. Running SQL Commands
- 39.4. Using Host Variables
- 39.5. Dynamic SQL
- 39.6. pgtypes Library
- 39.7. Using Descriptor Areas
- 39.8. Error Handling
- 39.9. Preprocessor Directives
- 39.10. Processing Embedded SQL Programs
- 39.11. Library Functions
- 39.12. Large Objects
- 39.13. C++ Applications
- 39.11. Library Functions
- 39.14. Embedded SQL Commands
- ALLOCATE DESCRIPTOR — allocate an SQL descriptor area
- CONNECT — establish a database connection
- DEALLOCATE DESCRIPTOR — deallocate an SQL descriptor area
- DECLARE — define a cursor
- DECLARE STATEMENT — declare SQL statement identifier
- DESCRIBE — obtain information about a prepared statement or result set
- DISCONNECT — terminate a database connection
- EXECUTE IMMEDIATE — dynamically prepare and execute a statement
- GET DESCRIPTOR — get information from an SQL descriptor area
- OPEN — open a dynamic cursor
- PREPARE — prepare a statement for execution
- SET AUTOCOMMIT — set the autocommit behavior of the current session
- SET CONNECTION — select a database connection
- SET DESCRIPTOR — set information in an SQL descriptor area
- TYPE — define a new data type
- VAR — define a variable
- WHENEVER — specify the action to be taken when an SQL statement causes a specific class condition to be raised
- CONNECT — establish a database connection
- ALLOCATE DESCRIPTOR — allocate an SQL descriptor area
- 39.15. Informix Compatibility Mode
- 39.16. Oracle Compatibility Mode
- 39.17. Internals
This chapter describes the embedded SQL package for Postgres Pro. 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.