Handling of large objects in DBD::Pg? - Mailing list pgsql-general

From M. Tavasti
Subject Handling of large objects in DBD::Pg?
Date
Msg-id m2lmr296d9.fsf@akvavitix.vuovasti.com
Whole thread Raw
List pgsql-general
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.

--
M. Tavasti

pgsql-general by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: RE: [DOCS] Re: Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?
Next
From: fabrizio.ermini@sysdat.it
Date:
Subject: Request for thoughts...