Help regarding INSERT INTO statement

From: "Smitha V(dot) Babu" <smitha(dot)v(at)sonata-software(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Help regarding INSERT INTO statement
Date: 2003-06-20 08:24:44
Message-ID: B0DA2772AD4CD711A8F300C04F1524A6FC5ACC@BG1MAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi all,
In my pgm i want to insert to the table a number of data..
I want toinsert it through variable names...
my program look like this

char *name="smitha";
char *address="Bangalore";

PQexexc(conn,"INSERT INTO data VALUES(name,address)");

whare data is the tablename having two fields UserName and UserAddress...

but this doesn't works

Can any one of u help me....

Thanking in advance..
smitha

*********************************************************************
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*********************************************************************

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message paul butler 2003-06-20 09:24:43 Re: Help regarding INSERT INTO statement
Previous Message Tom Lane 2003-06-20 00:49:03 Re: [WAS] postmaster fatal error LC_TIME:fr when launching