Re: Recommendation on bytea or blob for binary data like images

Thanks for the quick response. We will be using bytea from now on. :-)

- Leon

Tom Lane wrote:

>leon@oss.minimetria.com writes:
>  
>
>>Hi, I'd like to know what the official recommendation is on which binary
>>datatype to use for common small-binary size use.
>>    
>>
>
>If bytea will work for you, it's definitely the thing to use.  The only
>real drawback to bytea is that there's currently no API to read and
>write bytea values in a streaming fashion.  If your objects are small
>enough that you can load and store them as units, bytea is fine.
>
>BLOBs, on the other hand, have a number of drawbacks --- hard to dump,
>impossible to secure, etc.
>
>            regards, tom lane
>
>  
>