Re: Perl query error

Thanks for the help Josh.
Way too newbie to know what can or can't be done with DBI.

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

"Joshua b. Jore"
<josh(at)greentechnol To: Patrick Hatcher <PHatcher(at)macys(dot)com>
ogist.org> cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Perl query error
04/10/2002 10:22
AM

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm at a loss as to why you aren't just using normal SQL like so. Does the
DBD::Pg driver even support those slash commands?

Josh

my $file = '/home/ftp/pub/Incoming/postgres/ozupc.txt';
open FILE, ">$file" or die "Cannot open $file: $!";
$sth = $dbh->prepare("SELECT * FROM upc_export_v");
$sth->execute;
while (my @ary = $sth->fetchrow_array) {
print FILE join "\t", @ary;
}
undef $sth;
close FILE or die "Cannot close $file: $!";

Joshua b. Jore
http://www.greentechnologist.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8tHTlfexLsowstzcRApiXAKDfd15lbOKYNfZIDkp36JEGNRK41wCgjhST
r5jwqXdtMcxxDtymBWalwLE=
=61vB
-----END PGP SIGNATURE-----