Re: Using TEXT columns for binary content

Joe Conway <mail@joeconway.com> writes:
> 1) You have to encode to base64 on the way in (bytea has to be escaped
>     on INSERT/UPDATE too)
> 2) You have to decode to binary on the way out (depending on your
>     middleware, you can use a binary cursor for bytea and avoid the
>     decode on SELECT)

Note that the 7.4 protocol should make it a lot easier to use bytea for
binary data without any escaping ... although some amount of client
reprogramming would be needed ...

            regards, tom lane