ecpg

ecpg [options] file...

ecpg is the PostgreSQL embedded SQL preprocessor. It converts C programs with embedded SQL statements into regular C code that calls the ECPG runtime library, which in turn talks to the server through libpq.The tool reads .pgc files containing EXEC SQL statements embedded in C code and generates standard C files. By default the output for `prog.pgc` is written to `prog.c`. The generated code must be compiled and linked against libecpg (for example with `gcc prog.c -lecpg`), and the include path from `pg_config --includedir` is usually needed.

-o file

Write output to file.

Include search path.

Automatically generate C code from SQL code, currently for EXEC SQL TYPE declarations.

Compatibility mode: INFORMIX, INFORMIX_SE or ORACLE.

Define a C preprocessor symbol.

Process a header file. Implies -c and writes a .h file rather than a .c file.

Parse system include files as well.

Set a run-time behavior: no_indicator, prepare, questionmarks.

Turn on autocommit of transactions.

Print version, include path and other build information.

Print version and exit.

The generated C file links against libecpg, not libpq directly, so the PostgreSQL client development package must be installed. Compatibility modes change SQL parsing and null handling to match Informix or Oracle, and code written for one mode is generally not portable to another.

psql(1), pg_config(1), postgres(1)

Source code · Homepage · Documentation