Re: Need Help with BLOBs via DBI

From: Ludek Finstrle <xfinstrl(at)informatics(dot)muni(dot)cz>
To: Ralf Ullrich <rullrich(at)web(dot)de>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Need Help with BLOBs via DBI
Date: 2001-11-02 10:41:58
Message-ID: 20011102114158.Y26355@anxur.fi.muni.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Christof Petig 2001-11-02 11:26:40 Re: ECPG: Automatic Storage allocation for NULL-pointing
Previous Message Edward Pilipczuk 2001-11-02 07:02:29 Re: ECPG - connection name in "EXEC SQL AT ... " statement