Re: Testing embedded SQL in C

On Mon, 2007-02-12 at 15:16 -0500, HT NB wrote:
> Hi,
>
> How are you doing?
>
> First, I am testing if this email address is valid. It is the first
> time that I am using this account. I have a question about how to
> start write embedded SQL in C programming code. What are the basic
> requirements in the .pgc file to have the embedded SQL running.
>
> This is my coding which is aimed at testing if embedded SQL in C
> programming code is possible for my operating system Debian GNU/Linux.
>
> #include <stdio.h>
>
>
> int main ( )
> {
>
> EXEC SQL CONNECT TO database(at)sql(dot){ip address}.com :80;
>
> EXEC SQL INSERT INTO database (tab_number) VALUES (4);
> EXEC SQL SELECT * FROM database;
>
> return 1;
>
> }
>
>

see http://www.postgresql.org/docs/8.2/static/ecpg.html
see also
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/