I have added this to the DBDpg eg/ directory, and it will appear in the
next official release. Thanks.
---------------------------------------------------------------------------
[EMAIL PROTECTED] wrote:
> 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 <[EMAIL PROTECTED]> wrote:
> >
> > 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.
> >
> >
Content-Description: Large Object access functions
[ Attachment, skipping... ]
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
