Re: Testing embedded SQL in C - Mailing list pgsql-general

From Reid Thompson
Subject Re: Testing embedded SQL in C
Date
Msg-id 1171312879.7032.13.camel@localhost
Whole thread Raw
In response to Testing embedded SQL in C  ("HT NB" <hbnt@hotmail.com>)
List pgsql-general

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@sql.{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/

pgsql-general by date:

Previous
From: "Anton Melser"
Date:
Subject: Re: getting postgres to emulate mysql/sqlserver bit datatype
Next
From: "Anton Melser"
Date:
Subject: Re: getting postgres to emulate mysql/sqlserver bit datatype