libpq++: trouble getting "copy table from" to work... - Mailing list pgsql-interfaces

From Carlos Moreno
Subject libpq++: trouble getting "copy table from" to work...
Date
Msg-id 3CABF95D.5010909@mochima.com
Whole thread Raw
Responses Re: libpq++: trouble getting "copy table from" to work...  (jtv <jtv@xs4all.nl>)
List pgsql-interfaces
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
-- 





pgsql-interfaces by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PyGreSQL bug
Next
From: jtv
Date:
Subject: Re: libpq++: trouble getting "copy table from" to work...