Email::Store::Attachment - my losing battle

Matt Lawrence matt.lawrence at
Fri Dec 1 16:02:50 GMT 2006

Christopher Jones wrote:
>> So bytea is Postgres's BLOB type.
>> Cheers,
>> Luke
> Is bytea really equivalent though? The business about having to escape 
> certain characters makes it seem not so....
"The input format [of BLOB] is different from bytea, but the provided 
functions and operators are mostly the same."

It's hardly a show-stopper to have to escape your binary data, 
considering that the DBI driver will do it for you if you ask it to. 
Besides which, you could always use postgres' Large Objects, which allow 
you to stream your data in and out.


More information about the mailing list