| From: | Dorin Grunberg <dorin(at)visgen(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Problem with Large Objects |
| Date: | 1999-11-12 20:33:21 |
| Message-ID: | 4.2.0.58.19991112141528.00a56e60@pophost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 1999-11-13 02:04:12 | Re: [INTERFACES] THE Postgres WEB SITE |
| Previous Message | Oliver Elphick | 1999-11-12 19:56:53 | Re: [INTERFACES] RE: THE Postgres WEB SITE |