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...
pgsql-interfaces by date
|Next:||From: jtv||Date: 2002-04-04 09:08:05|
|Subject: Re: libpq++: trouble getting "copy table from" to work...|
|Previous:||From: Bruce Momjian||Date: 2002-04-04 06:44:31|
|Subject: Re: PyGreSQL bug|