Postgres Pro
Downloads
Home   >   mailing lists

Re: running \copy through perl dbi ? - Mailing list pgsql-general

From David G. Johnston
Subject Re: running \copy through perl dbi ?
Date
Msg-id CAKFQuwY6BfaE7MtDfZA41SOKmKHLMw-ZXU=YbZ=HLqyE-8uCaw@mail.gmail.com
Whole thread Raw
In response to running \copy through perl dbi ?  (David Gauthier <dfgpostgres@gmail.com>)
List pgsql-general
Tree view
On Fri, Dec 8, 2023 at 8:45 AM David Gauthier <dfgpostgres@gmail.com> wrote:

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 "\"

More accurately it is the psql application's meta-command.  There is no such thing as a generic client side command.

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 ???

 
The SQL command is just "COPY".  Search for how your driver exposes working with that command/protocol.

David J.

pgsql-general by date:

Previous
From: David Gauthier
Date:
Subject: running \copy through perl dbi ?
Next
From: Adrian Klaver
Date:
Subject: Re: running \copy through perl dbi ?