BLOB DBI func() interface under postgres

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: BLOB DBI func() interface under postgres
Date: 2000-06-27 13:10:41
Message-ID: 20000627151041.A1716@styx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

In DBD::Pg one can read (line 134):

$lobj_fd = $dbh->func($lobjId, $mode, 'lo_open');

But how is the LOB retrieved in the first place? If I pass the OID of an
existing LOB instance from a table the returned $lobj_fd is null. What
kind of $lobjId is one supposed to pass to this function to open a LOB?

The aim is to be able to read a LOB from a postgres DB without having to
lo_export the object to a file first. Can that be done with the
$dbh->func() interface? (using lo_open, lo_read, etc ..)

TIA

--
Louis-David Mitterrand - ldm(at)apartia(dot)org - http://www.apartia.fr

Hi, I am an alien .sig, and at the moment I am having sex to your
mind, by looking at your smile I can see that you like it.

Browse pgsql-general by date

  From Date Subject
Next Message Gilles DAROLD 2000-06-27 13:27:41 Search engine down ?
Previous Message Dale Anderson 2000-06-27 12:51:23 Re: DateTime fields