running \copy through perl dbi ?

Поиск
Список
Период
Сортировка
От David Gauthier
Тема running \copy through perl dbi ?
Дата
Msg-id CAEs=6DmZLwYre2AF8Li0HgL8AKFG3NwAzGEonLO0TGPk2fsZdg@mail.gmail.com
обсуждение исходный текст
Ответы Re: running \copy through perl dbi ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: running \copy through perl dbi ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: running \copy through perl dbi ?  (Vincent Veyron <vv.lists@wanadoo.fr>)
Re: running \copy through perl dbi ?  (Vincent Veyron <vv.lists@wanadoo.fr>)
Re: running \copy through perl dbi ?  (Vincent Veyron <vincent.veyron@libremen.org>)
Список pgsql-general
Hi:

I'm trying to run a PG client side "\copy" command from a perl script.  I tried using $dbh->do("\\copy ...") but it barffed when it saw the '\'...
ERROR:  syntax error at or near "\"

I can do this with a command line approach, attaching to the DB  then run using...
-c "\copy ...".  But I was wondering if there is a more elegant way to do this, maybe some sort of legal SQL command that Perl/DBI would swallow ???

Thanks in Advance !

В списке pgsql-general по дате отправления:

Предыдущее
От: Noel Jones
Дата:
Сообщение: Re: Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: running \copy through perl dbi ?