Message-ID: <3CABD1C3.8020606@mo.com>
Date: Wed, 03 Apr 2002 23:08:35 -0500
From: Carlos Moreno <moreno_at_mochima_dot_com@mo.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:0.9.4) Gecko/20011128 Netscape6/6.2.1
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Getting "copy from" to work from a C++ program
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit


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  (well, I
haven't tried copying from an actual file, since I have
the data in memory, and I'd like to avoid the overhead
to write it to a file first).  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.

Help?!!  :-(

Will it be necessary that I dump the data into a temporary
file and then do copy deleteme from tmpfile.txt ??

Thanks,

Carlos
--