ecpg man page on Scientific

Man page or keyword search:  
man Server   26626 pages
apropos Keyword Search (all sections)
Output format
Scientific logo
[printable version]

ECPG(1)			PostgreSQL Client Applications		       ECPG(1)

       ecpg - embedded SQL C preprocessor

       ecpg [ option... ]  file...

       ecpg  is	 the  embedded	SQL preprocessor for C programs. It converts C
       programs with embedded SQL statements to normal C code by replacing the
       SQL  invocations with special function calls. The output files can then
       be processed with any C compiler tool chain.

       ecpg will convert each input file given on the command line to the cor‐
       responding  C  output  file.  Input files preferably have the extension
       .pgc, in which case the extension will be replaced by .c	 to  determine
       the  output  file name. If the extension of the input file is not .pgc,
       then the output file name is computed by appending .c to the full  file
       name.  The output file name can also be overridden using the -o option.

       This  reference	page does not describe the embedded SQL language.  See
       in the documentation for more information on that topic.

       ecpg accepts the following command-line arguments:

       -c     Automatically generate certain C code from SQL code.  Currently,
	      this works for EXEC SQL TYPE.

       -C mode
	      Set a compatibility mode. mode can be INFORMIX or INFORMIX_SE.

       -D symbol
	      Define a C preprocessor symbol.

       -i     Parse system include files as well.

       -I directory
	      Specify  an additional include path, used to find files included
	      via EXEC	SQL  INCLUDE.  Defaults	 are  .	 (current  directory),
	      /usr/local/include,  the	PostgreSQL  include directory which is
	      defined at compile time (default: /usr/local/pgsql/include), and
	      /usr/include, in that order.

       -o filename
	      Specifies	 that  ecpg  should  write all its output to the given

       -r option
	      Selects a run-time  behavior.  Currently,	 option	 can  only  be

       -t     Turn  on autocommit of transactions. In this mode, each SQL com‐
	      mand is automatically committed unless it is inside an  explicit
	      transaction  block.  In the default mode, commands are committed
	      only when EXEC SQL COMMIT is issued.

       -v     Print additional	information  including	the  version  and  the
	      include path.

       --help Show a brief summary of the command usage, then exit.

	      Output version information, then exit.

       When  compiling the preprocessed C code files, the compiler needs to be
       able to find the ECPG header files in the PostgreSQL include directory.
       Therefore,  one	might have to use the -I option when invoking the com‐
       piler (e.g., -I/usr/local/pgsql/include).

       Programs using C code with embedded SQL have to be linked  against  the
       libecpg	  library,    for    example	using	the   linker   options
       -L/usr/local/pgsql/lib -lecpg.

       The value of either of these directories that is	 appropriate  for  the
       installation can be found out using pg_config(1).

       If you have an embedded SQL C source file named prog1.pgc, you can cre‐
       ate an executable program using the following sequence of commands:

       ecpg prog1.pgc
       cc -I/usr/local/pgsql/include -c prog1.c
       cc -o prog1 prog1.o -L/usr/local/pgsql/lib -lecpg

Application			  2013-10-08			       ECPG(1)

List of man pages available for Scientific

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
Vote for polarhome
Free Shell Accounts :: the biggest list on the net