select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 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
Historical version. PostgreSQL 7.2 reached end of support in February 2007. See the current version for supported releases.

Chapter 6. ecpg - Embedded SQL in C

This describes the embedded SQL package for PostgreSQL. It works with C and C++. It was written by Linus Tolke () and Michael Meskes (). The package is installed with the PostgreSQL distribution, and carries a similar license.

6.1. Why Embedded SQL?

Embedded SQL has advantages over other methods for handling SQL queries. It takes care of the tedious passing of information to and from variables in your C or C++ program. Many RDBMS packages support this embedded language.

There is an ANSI standard describing how the embedded language should work. ecpg was designed to match this standard as much as possible. It is possible to port embedded SQL programs written for other RDBMS to PostgreSQL.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.