From maphin.philip@nestgroup.net Tue May 1 11:53:17 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4157B9FB6EA for ; Tue, 1 May 2007 08:53:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 16655-06 for ; Tue, 1 May 2007 08:53:09 -0300 (ADT) X-Greylist: delayed 00:27:48.635189 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 46E7B9FB4E4 for ; Tue, 1 May 2007 08:53:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from ns2.nestgroup.net (unknown [203.200.158.40]) by svr4.postgresql.org (Postfix) with ESMTP id 165D75AF032 for ; Tue, 1 May 2007 11:25:23 +0000 (GMT) Received: from MAIL-TVM.tvm.nestgroup.net ([192.168.192.74]) by ns2.nestgroup.net (8.13.1/8.13.1) with ESMTP id l41BTio0021542 for ; Tue, 1 May 2007 16:59:45 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C78BE3.3C89CBB4" Subject: postgres and c Date: Tue, 1 May 2007 16:55:05 +0530 Message-ID: <9A1299C7A40D7447A108107E951450CAEFDBF1@MAIL-TVM.tvm.nestgroup.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: postgres and c Thread-Index: AceL415Oo6jOOueCT5GPmGKH45Qf4A== From: "Maphin Philip" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.115 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_90_100=0.113, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200705/1 X-Sequence-Number: 6508 This is a multi-part message in MIME format. ------_=_NextPart_001_01C78BE3.3C89CBB4 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable How can we use c programs to manipulate data in postgres database? =20 =20 =20 Thanks =20 ------_=_NextPart_001_01C78BE3.3C89CBB4 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

How can we use c programs to manipulate data in = postgres database?

 

 

 

Thanks

 

------_=_NextPart_001_01C78BE3.3C89CBB4-- From Reid.Thompson@ateb.com Tue May 1 12:22:41 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3917F9FB58C for ; Tue, 1 May 2007 09:22:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 48151-02 for ; Tue, 1 May 2007 09:22:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 762A09FB52A for ; Tue, 1 May 2007 09:22:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from relay.mail.twtelecom.net (relay.mail.twtelecom.net [64.129.67.76]) by svr4.postgresql.org (Postfix) with ESMTP id 515AF5AF03A for ; Tue, 1 May 2007 12:22:25 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by relay.mail.twtelecom.net (Postfix) with ESMTP id E8E48588932; Tue, 1 May 2007 06:22:23 -0600 (MDT) X-Virus-Scanned: amavisd-new at twtelecom.net Received: from relay.mail.twtelecom.net ([127.0.0.1]) by localhost (relay-3.dnvr.twtelecom.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 9-UonL4y0vIc; Tue, 1 May 2007 06:22:22 -0600 (MDT) Received: from sr002-2k3exc.ateb.com (ateb.com [66.193.74.200]) by relay.mail.twtelecom.net (Postfix) with SMTP id CEF37588A7F; Tue, 1 May 2007 06:22:21 -0600 (MDT) Received: from 192.168.100.14 ([192.168.100.14]) by sr002-2k3exc.ateb.com ([192.168.100.228]) with Microsoft Exchange Server HTTP-DAV ; Tue, 1 May 2007 12:23:39 +0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C78BEB.8CCBB9A8" Received: from jhereg by sr002-2k3exc.ateb.com; 01 May 2007 08:19:51 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 X-Mailer: Evolution 2.10.0 Content-class: urn:content-classes:message Subject: Re: postgres and c Date: Tue, 1 May 2007 08:19:51 -0400 Message-ID: <1178021991.25678.17.camel@jhereg> In-Reply-To: <9A1299C7A40D7447A108107E951450CAEFDBF1@MAIL-TVM.tvm.nestgroup.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [INTERFACES] postgres and c Thread-Index: AceL64zLCB2L1HBsRUeKK4G3ubfGHQ== References: <9A1299C7A40D7447A108107E951450CAEFDBF1@MAIL-TVM.tvm.nestgroup.net> From: "Reid Thompson" To: "Maphin Philip" Cc: Reply-To: "Reid Thompson" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.181 tagged_above=0 required=5 tests=AWL=0.178, BAYES_50=0.001, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001 X-Spam-Level: X-Archive-Number: 200705/3 X-Sequence-Number: 6510 This is a multi-part message in MIME format. ------_=_NextPart_001_01C78BEB.8CCBB9A8 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable On Tue, 2007-05-01 at 16:55 +0530, Maphin Philip wrote: > How can we use c programs to manipulate data in postgres database? >=20 > =20 >=20 > =20 >=20 > =20 >=20 > Thanks >=20 > =20 >=20 > http://www.postgresql.org/docs/8.2/static/libpq.html ------_=_NextPart_001_01C78BEB.8CCBB9A8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Re: [INTERFACES] postgres and c

On Tue, 2007-05-01 at 16:55 +0530, Maphin Philip = wrote:
> How can we use c programs to manipulate data in postgres = database?
>
> 
>
> 
>
> 
>
> Thanks
>
> 
>
> http://www.= postgresql.org/docs/8.2/static/libpq.html

------_=_NextPart_001_01C78BEB.8CCBB9A8-- From khanzahid235@yahoo.com Tue May 1 12:20:33 2007 Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 248909FB527 for ; Tue, 1 May 2007 09:20:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 18883-08 for ; Tue, 1 May 2007 09:20:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54515.mail.yahoo.com (web54515.mail.yahoo.com [206.190.49.165]) by postgresql.org (Postfix) with SMTP id CC3929FB253 for ; Tue, 1 May 2007 09:20:26 -0300 (ADT) Received: (qmail 43118 invoked by uid 60001); 1 May 2007 12:20:25 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=QwjtfNDB37NNaQviIIfVEIoxTEYR3z/Nrkc9QYtTQI53RewYLO2LAGWQCy4OJvLHDClW+JGQ1JSQx5nrsGlHoCAk58mF9MbbPVIkeESHQu8q2Sv8xVOviB5qwXqx2gJIPZU0HBVeyDjNSF2im/ibf3ANh7ktQ1J/u170xI86k5E=; X-YMail-OSG: SHn732QVM1moH8_HJ7O6NKnJF4XWooWzfAsTlzI0RfZvHRvIQ1ItBOIVR022AspIXDk3vNI2GfEOHkL.._pgtCpTiPWPi._lzZ8N Received: from [203.215.160.146] by web54515.mail.yahoo.com via HTTP; Tue, 01 May 2007 05:20:25 PDT Date: Tue, 1 May 2007 05:20:25 -0700 (PDT) From: Zahid Khan Subject: Re: postgres and c To: Maphin Philip , pgsql-interfaces@postgresql.org In-Reply-To: <9A1299C7A40D7447A108107E951450CAEFDBF1@MAIL-TVM.tvm.nestgroup.net> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <437622.42143.qm@web54515.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.432 tagged_above=0 required=5 tests=AWL=-0.324, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: X-Archive-Number: 200705/2 X-Sequence-Number: 6509 You can use LIBPQ for that. http://www.postgresql.org/docs/8.2/static/libpq.html Thanks, Zahid K. --- Maphin Philip wrote: > How can we use c programs to manipulate data in > postgres database? > > > > > > > > Thanks > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From meskes@postgresql.org Tue May 1 15:49:22 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C505F9FA433 for ; Tue, 1 May 2007 12:49:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 61929-10 for ; Tue, 1 May 2007 12:49:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 0F0D89FA617 for ; Tue, 1 May 2007 12:49:18 -0300 (ADT) Received: from feivel (p54BBF8F2.dip.t-dialin.net [84.187.248.242]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 24CAED7654; Tue, 1 May 2007 17:49:14 +0200 (CEST) Received: by feivel (Postfix, from userid 1000) id 9F52DD6C4A; Tue, 1 May 2007 17:49:13 +0200 (CEST) Date: Tue, 1 May 2007 17:49:13 +0200 From: Michael Meskes To: Reid Thompson Cc: Maphin Philip , pgsql-interfaces@postgresql.org Subject: Re: postgres and c Message-ID: <20070501154913.GA23786@feivel.credativ.de> Mail-Followup-To: Reid Thompson , Maphin Philip , pgsql-interfaces@postgresql.org References: <9A1299C7A40D7447A108107E951450CAEFDBF1@MAIL-TVM.tvm.nestgroup.net> <1178021991.25678.17.camel@jhereg> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1178021991.25678.17.camel@jhereg> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/4 X-Sequence-Number: 6511 On Tue, May 01, 2007 at 08:19:51AM -0400, Reid Thompson wrote: > > http://www.postgresql.org/docs/8.2/static/libpq.html And of course also ecpg: http://www.postgresql.org/docs/8.2/static/ecpg.html Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! From Reid.Thompson@ateb.com Tue May 1 16:02:00 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 041569FB255 for ; Tue, 1 May 2007 13:02:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 78154-05 for ; Tue, 1 May 2007 13:01:57 -0300 (ADT) X-Greylist: delayed 03:39:32.169557 by SQLgrey-1.7.4 Received: from relay.mail.twtelecom.net (relay.mail.twtelecom.net [64.129.67.72]) by postgresql.org (Postfix) with ESMTP id 5CD0A9FA49D for ; Tue, 1 May 2007 13:01:57 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by relay.mail.twtelecom.net (Postfix) with ESMTP id 723367BC533; Tue, 1 May 2007 10:01:56 -0600 (MDT) X-Virus-Scanned: amavisd-new at twtelecom.net Received: from relay.mail.twtelecom.net ([127.0.0.1]) by localhost (relay-2.dnvr.twtelecom.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id LNtsHlmRBmde; Tue, 1 May 2007 10:01:55 -0600 (MDT) Received: from sr002-2k3exc.ateb.com (ateb.com [66.193.74.200]) by relay.mail.twtelecom.net (Postfix) with SMTP id 45AB77BC7B7; Tue, 1 May 2007 10:01:54 -0600 (MDT) Received: from 192.168.100.14 ([192.168.100.14]) by sr002-2k3exc.ateb.com ([192.168.100.228]) with Microsoft Exchange Server HTTP-DAV ; Tue, 1 May 2007 16:05:11 +0000 Received: from jhereg by sr002-2k3exc.ateb.com; 01 May 2007 12:01:21 -0400 Subject: Re: postgres and c From: Reid Thompson Reply-To: Reid.Thompson@ateb.com To: Michael Meskes Cc: Maphin Philip , pgsql-interfaces@postgresql.org In-Reply-To: <20070501154913.GA23786@feivel.credativ.de> References: <9A1299C7A40D7447A108107E951450CAEFDBF1@MAIL-TVM.tvm.nestgroup.net> <1178021991.25678.17.camel@jhereg> <20070501154913.GA23786@feivel.credativ.de> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Tue, 01 May 2007 12:01:20 -0400 Message-Id: <1178035280.8791.1.camel@jhereg> Mime-Version: 1.0 X-Mailer: Evolution 2.10.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/5 X-Sequence-Number: 6512 On Tue, 2007-05-01 at 17:49 +0200, Michael Meskes wrote: > On Tue, May 01, 2007 at 08:19:51AM -0400, Reid Thompson wrote: > > > http://www.postgresql.org/docs/8.2/static/libpq.html > > And of course also ecpg: > > http://www.postgresql.org/docs/8.2/static/ecpg.html > > Michael yep -- i've had very good results using ecpg. From ken_jennings@bellsouth.net Tue May 1 23:02:01 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D49079FB93E for ; Tue, 1 May 2007 20:02:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 94352-10 for ; Tue, 1 May 2007 20:01:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from imf23aec.mail.bellsouth.net (imf23aec.mail.bellsouth.net [205.152.59.71]) by postgresql.org (Postfix) with ESMTP id C6B789FA2DF for ; Tue, 1 May 2007 20:01:57 -0300 (ADT) Received: from ibm66aec.bellsouth.net ([65.3.164.136]) by imf23aec.mail.bellsouth.net with ESMTP id <20070501230156.PILV17728.imf23aec.mail.bellsouth.net@ibm66aec.bellsouth.net> for ; Tue, 1 May 2007 19:01:56 -0400 Received: from wolverine.481sumter.33325.net ([65.3.164.136]) by ibm66aec.bellsouth.net with ESMTP id <20070501230155.TJHF12853.ibm66aec.bellsouth.net@wolverine.481sumter.33325.net> for ; Tue, 1 May 2007 19:01:55 -0400 From: Ken Jennings To: pgsql-interfaces@postgresql.org Subject: Re: postgres and c Date: Tue, 1 May 2007 19:01:54 -0400 User-Agent: KMail/1.9.5 References: <9A1299C7A40D7447A108107E951450CAEFDBF1@MAIL-TVM.tvm.nestgroup.net> <20070501154913.GA23786@feivel.credativ.de> <1178035280.8791.1.camel@jhereg> In-Reply-To: <1178035280.8791.1.camel@jhereg> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200705011901.54655.ken_jennings@bellsouth.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.858 tagged_above=0 required=5 tests=BAYES_40=-0.185, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, FORGED_RCVD_HELO=0.135 X-Spam-Level: * X-Archive-Number: 200705/6 X-Sequence-Number: 6513 On Tuesday 2007-05-01 12:01, Reid Thompson wrote: > On Tue, 2007-05-01 at 17:49 +0200, Michael Meskes wrote: > > On Tue, May 01, 2007 at 08:19:51AM -0400, Reid Thompson wrote: > > > > http://www.postgresql.org/docs/8.2/static/libpq.html > > > > And of course also ecpg: > > > > http://www.postgresql.org/docs/8.2/static/ecpg.html > yep -- i've had very good results using ecpg. Go to http://en.wikipedia.org/wiki/Postgresql The last entry points to a simple example program for Embedded/SQL: "Test_PGC, Example embedded SQL/C program for PostgreSQL showing database operations and SQLSTATE testing." From reid.thompson@ateb.com Wed May 2 02:56:27 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5FB079FB9BB for ; Tue, 1 May 2007 23:56:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 35651-03 for ; Tue, 1 May 2007 23:56:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from relay.mail.twtelecom.net (relay.mail.twtelecom.net [64.129.67.77]) by postgresql.org (Postfix) with ESMTP id 533E99FB90F for ; Tue, 1 May 2007 23:56:24 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by relay.mail.twtelecom.net (Postfix) with ESMTP id D265D53C823; Tue, 1 May 2007 20:56:22 -0600 (MDT) X-Virus-Scanned: amavisd-new at twtelecom.net Received: from relay.mail.twtelecom.net ([127.0.0.1]) by localhost (relay-4.dnvr.twtelecom.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id NzumJBgptVGE; Tue, 1 May 2007 20:56:20 -0600 (MDT) Received: from sr002-2k3exc.ateb.com (ateb.com [66.193.74.200]) by relay.mail.twtelecom.net (Postfix) with SMTP id DBAD653C807; Tue, 1 May 2007 20:56:19 -0600 (MDT) Received: from [192.168.2.106] ([67.76.32.182] RDNS failed) by sr002-2k3exc.ateb.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 1 May 2007 22:56:12 -0400 Message-ID: <4637FD1E.2080805@ateb.com> Date: Tue, 01 May 2007 22:53:18 -0400 From: Reid Thompson User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Ken Jennings CC: pgsql-interfaces@postgresql.org Subject: Re: postgres and c References: <9A1299C7A40D7447A108107E951450CAEFDBF1@MAIL-TVM.tvm.nestgroup.net> <20070501154913.GA23786@feivel.credativ.de> <1178035280.8791.1.camel@jhereg> <200705011901.54655.ken_jennings@bellsouth.net> In-Reply-To: <200705011901.54655.ken_jennings@bellsouth.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 02 May 2007 02:56:12.0829 (UTC) FILETIME=[71916CD0:01C78C65] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/7 X-Sequence-Number: 6514 Ken Jennings wrote: > On Tuesday 2007-05-01 12:01, Reid Thompson wrote: > >> On Tue, 2007-05-01 at 17:49 +0200, Michael Meskes wrote: >> >>> On Tue, May 01, 2007 at 08:19:51AM -0400, Reid Thompson wrote: >>> >>>>> http://www.postgresql.org/docs/8.2/static/libpq.html >>>>> >>> And of course also ecpg: >>> >>> http://www.postgresql.org/docs/8.2/static/ecpg.html >>> > > >> yep -- i've had very good results using ecpg. >> > > Go to http://en.wikipedia.org/wiki/Postgresql > > The last entry points to a simple example program for Embedded/SQL: > "Test_PGC, Example embedded SQL/C program for PostgreSQL showing database > operations and SQLSTATE testing." > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > also see http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/ and http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/