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@greentechnol To: Patrick Hatcher <PHatcher@macys.com>
ogist.org> cc: pgsql-novice@postgresql.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-----