question on accessing PostgreSQL with C

From: hoelc <hoelc(at)pd(dot)jaring(dot)my>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: question on accessing PostgreSQL with C
Date: 1999-02-06 03:05:18
Message-ID: 36BBB16D.F0F88A26@pd.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello,
I'm a newbee in PostgreSQL, Linux world. Currently facing some problem
in building a simple application. I'm trying to write a C program that
get input from user, then update (insert / change) the database, or
retrieve selected data.

Questions:
(1) Where to get more example of communicating with PostgreSQL with C
program?

(2) How to put variables into the SQL?
I use C program to access PostgreSQL with libpq, and use PQexec( )
to send the query. One of the failed example of mine,
:
/* get input from user, a string and an integer */
:
PQexec(conn,"insert into NameList (name,id) values (%s,%d)
.......
:
/* I'm trying to put variables of string and integer into the
query */

(3) How to check who are the users in PostgreSQL system?

Please advise.
Thanks & Regards,
LCH

Browse pgsql-interfaces by date

  From Date Subject
Next Message hoelc 1999-02-06 03:21:47 (no subject)
Previous Message Andreas Kaschke 1999-02-05 22:06:07 (no subject)