| 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: | Whole Thread | Raw Message | 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
| 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 |