Re: bytea and text

On 2009-11-26, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> Hi list,
>
> 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 (?).

use bytea and convert to/from base64 if you can't use the binary
interface and find the text interface inconvenient.

this will make the data over 1/3 bigger.