> im desperately looking for documentation on handling blobs in postgres via
> dbi. I searched at
> http://www.postgresql.org/idocs/index.php?programmer.html but couldn't
> find something about perl.
> does anyone have a tutorial or something else?
First, in PostgreSQL you have two options:
1. with 7.1 and later, just use type 'text', since the 8KB row limit
is now history. The advantage of this method is you don't need
to learn any new API.
A problem with this is you can't readily store binary data yet; if
your data is binary you'll need to encode it some way first,
e.g. base64.
2. PostgreSQL does support 'large objects' (which it did prior to 7.1
too) and these can be accessed using the DBG::Pg module via driver
specific functions -- search in the DBD::Pg documentation for
'lo_creat'.
Searching the PostgreSQL mailing list archive will turn up some
discussion of different ways to store and manipulate large objects:
http://fts.postgresql.org
Regards,
Giles
