Thread: 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