From: Enrique Rodriguez Lazaro <enrique@xpress.es>
To: PSQL ADMIN <pgsql-admin@postgreSQL.org>
Subject: Re: [ADMIN] Ghost insert
Date: Thu, 23 Dec 1999 11:27:01 +0100
Message-ID: <3861F8F5.E6191703@xpress.es> (raw)
References: <38611DB0.91825980@xpress.es>
<19991222211936.C5019@clbh.hu>
SZALAI Karoly wrote:
>
> On Wed, Dec 22, 1999 at 07:51:28PM +0100, Enrique Rodriguez Lazaro wrote:
> > res1=PQexec(conn,temp_string);
> > tuplas=PQresultStatus(res1);
> so, i think, you have to close the command. my program do this:
>
> (the REAL contains the line, what i want to copy to the table)
>
> PQexec(conn,"copy phone from stdin using delimiters '|'\n");
> PQputline(conn,REAL);
> PQputline(conn,"\\.\n");
> ^^^^^^^^^^^^^^^^^^^^^^^^you need this line (maybe)
>
> if it's not working, mail me, and i find my old .c programs :-)
> --
> CZW
Thanks for you answer.
Your solution is based on copy command. Isn't posible do it with a
insert command?
I want insert data on my database from a web's form. I think it's better
use the insert command, it is?
Thanks.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: enrique@xpress.es, pgsql-admin@postgreSQL.org
Subject: Re: [ADMIN] Ghost insert
In-Reply-To: <3861F8F5.E6191703@xpress.es>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox