Re: bytea or blobs?

On Wednesday 18 February 2004 06:44, Dana Hudes wrote:
>
> At least with base64 I have ample libraries and can convert my data
> before sending to sql or after receiving from sql. It becomes my
> application's issue. Mind, this bloats the data considerably.
> escape is less bloat but I have to recreate the encode/decode in my app,
> so far as I see.

Less bloat than you might expect - large values are TOASTed and compressed. 
I'm guessing a lot of your redundancy will be eliminated.

Having said that, bytea's purpose in life is to store your binary data.

--  Richard Huxton Archonet Ltd