From: Dorin Grunberg <dorin@visgen.com>
To: pgsql-interfaces@postgresql.org
Subject: Problem with Large Objects
Date: Fri, 12 Nov 1999 14:33:21 -0600
Message-ID: <4.2.0.58.19991112141528.00a56e60@pophost> (raw)
I am trying to recreate the example from the Postgresql manual using Perl
and DBI.
I was able to insert the image 'inside' the table. I checked the /tmp
directory to see if it is there.
When I run the following lines I get the output an "1"
my $sth = $dbh->prepare_cached(qq{SELECT lo_export(image.file,
'/tmp/Patti.jpg') from image WHERE name='picture'}) || die "Can't prepare
statement: $DBI::errstr";
my $rc = $sth->execute || die "Can't execute statement:
$DBI::errstr";
while (($picture) = $sth->fetchrow_array() ) {
print $picture;
}
What am I doing wrong here?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: dorin@visgen.com
Subject: Re: Problem with Large Objects
In-Reply-To: <4.2.0.58.19991112141528.00a56e60@pophost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox