Re: Need Help with BLOBs via DBI - Mailing list pgsql-interfaces

From Ludek Finstrle
Subject Re: Need Help with BLOBs via DBI
Date
Msg-id 20011102114158.Y26355@anxur.fi.muni.cz
Whole thread Raw
In response to Need Help with BLOBs via DBI  (rullrich@web.de (Ralf Ullrich))
List pgsql-interfaces
> 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


pgsql-interfaces by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ECPG - connection name in "EXEC SQL AT ... " statement
Next
From: Christof Petig
Date:
Subject: Re: ECPG: Automatic Storage allocation for NULL-pointing