libpq++: trouble getting "copy table from" to work...

Поиск
Список
Период
Сортировка
От Carlos Moreno
Тема libpq++: trouble getting "copy table from" to work...
Дата
Msg-id 3CABF95D.5010909@mochima.com
обсуждение исходный текст
Ответы Re: libpq++: trouble getting "copy table from" to work...  (jtv <jtv@xs4all.nl>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: PyGreSQL bug
Следующее
От: jtv
Дата:
Сообщение: Re: libpq++: trouble getting "copy table from" to work...