On Fri, 8 Dec 2023 10:45:28 -0500
David Gauthier <dfgpostgres@xxxxxxxxx> 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 "\"
Hi David,
This works for me :
#create file
my $sql = qq {\\copy ( $sub_query ) to '$location' with null as '' delimiter ';' csv header } ;
my $db_name = 'xxxxxx' ;
my @args = ( 'psql', '-c', $sql, $db_name ) ;
system( @args ) == 0 or die "Bad copy: $?" ;
--
Bien à vous, Vincent Veyron
https://marica.fr
Logiciel de gestion des contentieux juridiques, des contrats et des sinistres d'assurance
