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(at)oss(dot)minimetria(dot)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
>
>
>