Re: Handling of large objects in DBD::Pg? (fwd)
Attached are large object read and write functions I wrote based on
information I gleened from the DBD::Pg install test script.
They read and write to buffers rather than files because my
information wasn't comming from a file and wasn't going to one. However
if you need the data to go to a file you can either open a file handle
yourself in these methods and read into a scalar or write out from one, OR
you can scan the test.pl file in the DBD::Pg install to see how to use the
proper file based read and write Pg calls.
M. Tavasti <tawz@nic.fi> wrote:
Show quoted text
How do I handle large objects in DBD:Pg (perl DBI interface to
postgresql)?I've tried to do like this, but not successfull, it looks like there
is no data inserted. I tried to see in psql is there something, doing
SELECT lo_export(data,"/tmp/foofaa.txt") from foofaa where id=XXXX;$obj_ins = $dbh->prepare(q{
INSERT INTO foofaa
(id,entry,data)
VALUES
(?,?,?)});$obj = $dbh->func("./$dir/obj.txt", 'lo_import');
$obj_ins->execute($id,$ent,$obj);Manual page of DBD:Pg if confusing for lo_export:
$ret = $dbh->func($lobjId, 'lo_export');
Exports a large object into a Unix file. Returns
false upon failure, true otherwise.To what file....
Any help welcome.
Attachments:
lotest.pltext/plain; charset=US-ASCII; name=lotest.plDownload
Import Notes
Reply to msg id not found: Pine.LNX.4.30.0102231420010.30639-100000@pippin.salon.com