Re: bytea and text

"Jean-Yves F. Barbier" <12ukwn@gmail.com> writes:
> I'm asking myself what solution for storing pictures is the best:

> * using a BYTEA column type, and having no intrinsic compression gain
>    because a picture it almost every time already compressed,

> * using a TEXT column type, and store a Base64(picture) in it; it should
>    take benefits of intrinsic compression (?).

At best, the compression would get rid of the overhead you added by
converting to base64.  It probably wouldn't completely succeed at that,
though, meaning the second alternative is always a loser.

            regards, tom lane