select open change scope Open full search

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

Unsupported versions: 8.1 / 8.0 / 7.4 / 7.3
Historical version. PostgreSQL 8.1 reached end of support in November 2010. See the current manual for supported releases.

30.10. Including Files

To include an external file into your embedded SQL program, use:

EXEC SQL INCLUDE filename;

The embedded SQL preprocessor will look for a file named filename.h, preprocess it, and include it in the resulting C output. Thus, embedded SQL statements in the included file are handled correctly.

Note that this is not the same as

#include <filename.h>

because this file would not be subject to SQL command preprocessing. Naturally, you can continue to use the C #include directive to include other header files.

Note: The include file name is case-sensitive, even though the rest of the EXEC SQL INCLUDE command follows the normal SQL case-sensitivity rules.

Report a documentation issue

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