Joe Conway <mail(at)joeconway(dot)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