Chapter 52. ecpg - Embedded SQL in C

Table of Contents
Why Embedded SQL?
The Concept
How To Use ecpg
Limitations
Porting From Other RDBMS Packages
Installation
For the Developer

This describes an embedded SQL in C package for Postgres. It is written by Linus Tolke and Michael Meskes.

Note: Permission is granted to copy and use in the same way as you are allowed to copy and use the rest of PostgreSQL.

Why Embedded SQL?

Embedded SQL has some small advantages over other ways to handle SQL queries. It takes care of all the tedious moving of information to and from variables in your 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 meet this standard as much as possible. So it is possible to port programs with embedded SQL written for other RDBMS packages to Postgres and thus promoting the spirit of free software.