1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
<!-- manual page source format generated by PolyglotMan v3.0.4, -->
<!-- available via anonymous ftp from ftp.cs.berkeley.edu:/ucb/people/phelps/tcltk/rman.tar.Z -->
<HTML>
<HEAD>
<TITLE>ECPG(UNIX) manual page</TITLE>
</HEAD>
<BODY>
<A HREF="pgsql.html">PostgreSQL Contents</A>
<H2><A NAME="sect0" HREF="#toc0">NAME </A></H2>
ecpg - embedded SQL preprocessor for C
<H2><A NAME="sect1" HREF="#toc1">SYNOPSIS </A></H2>
<B>ecpg</B> [<B>-v</B> ] [<B>-d</B> ] [<B>-o</B>
outfile ] file1 [file2] [...]
<H2><A NAME="sect2" HREF="#toc2">DESCRIPTION </A></H2>
ecpg an embedded SQL in C package
for PostgreSQL. It enables you to develop C programs with embedded SQL
code. <P>
<I>ecpg</I> understands the following command-line options:
<DL>
<DT><B>-v</B> </DT>
<DD>Print version
information. </DD>
<DT><B>-d</B> </DT>
<DD>Turn on debugging. </DD>
<DT><B>-o</B> outfile </DT>
<DD>Specifies that <I>ecpg</I> should
write all its output to <I>outfile</I>.<I>If</I>no<I>such</I>option<I>is</I>given<I>the</I>output<I>is</I>written<I>to</I>foo.c
if the input file was name foo.pgc or to foo.bar.c if the input file was
foo.bar. </DD>
<DT><B>file1, file2, ...</B> </DT>
<DD>The files to be processed. </DD>
</DL>
<H2><A NAME="sect3" HREF="#toc3">BUGS </A></H2>
The return code
is alway -1 in case of an error. You cannot see which error occured by examining
the return code.
<DL>
<DT>The cursor is opened when the declare statement is issued.
</DT>
<DD></DD>
<DT>ecpg does not understand enum datatypes. </DT>
<DD></DD>
<DT>The is no exec sql prepare statement.
</DT>
<DD></DD>
<DT>The complete structure definition has to be listed inside the declare
section for ecpg to be able to understand it. </DT>
<DD></DD>
<DT>Each variable has to be
defined on a line on its own. </DT>
<DD></DD>
<DT>There is no way yet to fill a complete array
with one call except arrays of [unsigned] char </DT>
<DD>which are considered strings.
</DD>
<DT>ecpg cannot use pointer variables except [unsigned] char * </DT>
<DD></DD>
</DL>
<H2><A NAME="sect4" HREF="#toc4">RETURN VALUE
</A></H2>
<I>ecpg</I> returns 0 to the shell on successful completion, -1 for errors,
<H2><A NAME="sect5" HREF="#toc5">SEE
ALSO </A></H2>
<A HREF="cc.1.html">cc(1)</A>
. <P>
<P>
<HR><P>
<A NAME="toc"><B>Table of Contents</B></A><P>
<UL>
<LI><A NAME="toc0" HREF="#sect0">NAME</A></LI>
<LI><A NAME="toc1" HREF="#sect1">SYNOPSIS</A></LI>
<LI><A NAME="toc2" HREF="#sect2">DESCRIPTION</A></LI>
<LI><A NAME="toc3" HREF="#sect3">BUGS</A></LI>
<LI><A NAME="toc4" HREF="#sect4">RETURN VALUE</A></LI>
<LI><A NAME="toc5" HREF="#sect5">SEE ALSO</A></LI>
</UL>
</BODY></HTML>
|
