Обсуждение: Need Help with BLOBs via DBI

Hi, 

im new to working with postgresql. As my backend language i' ve chosen
perl and DBI. Everything works fine unless i try to insert the
contents of a binary file via an webinterface in an BLOB-field. I read
dbd::pg, but still i cant imagine how to do it. does anybody maybe
have an working example?

Thnx,

Ralf

> im new to working with postgresql. As my backend language i' ve chosen
> perl and DBI. Everything works fine unless i try to insert the
> contents of a binary file via an webinterface in an BLOB-field. I read
> dbd::pg, but still i cant imagine how to do it. does anybody maybe
> have an working example?

See man DBD::Pg. There is $dbh->func(...) which support work with
lo [e.g. $lobj_fd = $dbh->func($lobjId, $mode, 'lo_open');].
You can read in Postgres doc about working with large objects.

Regards

Luf