Received: from maria.xpress.es (bestia.xpress.es [194.224.86.3]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA99709; Thu, 23 Dec 1999 05:25:36 -0500 (EST) (envelope-from enrique@xpress.es) Received: from xpress.es (idefix.xpress.es [194.224.86.59]) by maria.xpress.es (8.8.8/8.8.8) with ESMTP id LAA23028; Thu, 23 Dec 1999 11:20:16 GMT Sender: enrique@bestia.xpress.es Message-ID: <3861F8F5.E6191703@xpress.es> Date: Thu, 23 Dec 1999 11:27:01 +0100 From: Enrique Rodriguez Lazaro X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.0.36 i586) X-Accept-Language: en MIME-Version: 1.0 To: PSQL ADMIN Subject: Re: [ADMIN] Ghost insert References: <38611DB0.91825980@xpress.es> <19991222211936.C5019@clbh.hu> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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.