running \copy through perl dbi ?

David Gauthier <dfgpostgres@gmail.com>

From: David Gauthier <dfgpostgres@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2023-12-08T15:45:28Z
Lists: 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 !