Perl query error

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Perl query error
Date: 2002-04-10 16:45:08
Message-ID: OF4934A5A6.09B8BDA3-ON88256B97.005B9AD8@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,
I'm trying to use a Perl script to export a query result to a text file.
The result should have no header or footer information. However, when I
run the script, I get a message: DBD::Pg::st execute failed: ERROR:
parser: parse error at or near "/" at ./mdcupc.pl line 189.

Here's the section where the error occurs:

# Send command to not print header or footer information
my $query = $dbh->prepare("\t")
or die "Cannot prepare SQL statement: $DBI::errstr\n";
$query->execute ;

# Send command to not print header or footer information
$query = $dbh->prepare("select * from upc_export_v \g
/home/ftp/pub/Incoming/postgres/ozupc.txt;")
or die "Cannot prepare SQL statement: $DBI::errstr\n";
$query->execute ;

Any help would be greatly appreciated.

Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-932-0610 office

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Hatcher 2002-04-10 17:19:59 Re: Perl query error
Previous Message Josh Berkus 2002-04-10 16:02:07 Re: Question on oid's