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@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-----