Received: from VL-MS-MR001.sc1.videotron.ca (relais.videotron.ca
	[24.201.245.36])
	by postgresql.org (Postfix) with ESMTP id C9A22475904
	for <pgsql-interfaces@postgresql.org>;
	Thu,  4 Apr 2002 01:58:10 -0500 (EST)
Received: from mochima.com ([24.202.14.35]) by
	VL-MS-MR001.sc1.videotron.ca (Netscape Messaging Server 4.15)
	with ESMTP id GU17CY04.0CA for
	<pgsql-interfaces@postgresql.org>; Thu, 4 Apr 2002 01:58:10 -0500
Message-ID: <3CABF95D.5010909@mochima.com>
Date: Thu, 04 Apr 2002 01:57:33 -0500
From: Carlos Moreno <moreno@mochima.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:0.9.4) Gecko/20011128 Netscape6/6.2.1
X-Accept-Language: en-us
MIME-Version: 1.0
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: libpq++:  trouble getting "copy table from" to work...
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200204/4
X-Sequence-Number: 2546


Hi,

I'm trying to insert several records into a table in one shot
(from a C++ program, that is).

All my attempts to use "copy from" have failed.  Is it
possible??  I've tried things like:

PgDatabase db(" ..... ");
db.Exec ("copy deleteme from stdin\n1\tName1\n2\tName2");

And similar things  (with a ; after stdin, with a \n. or
\n\\. at the end of the string -- they all fail with an
ErrorMessage() indicating a syntax error in the statement.

I even tried creating a temporary file and then using
copy from 'filename' -- but I get an error message saying
that I need superuser access to be allowed to copy from
and to regular files...

Help?!!  :-(


Thanks,

Carlos
--