Re: bytea or blobs? - Mailing list pgsql-sql

From Richard Huxton
Subject Re: bytea or blobs?
Date
Msg-id 200402180944.42239.dev@archonet.com
Whole thread Raw
In response to Re: bytea or blobs?  (Dana Hudes <dhudes@tcp-ip.info>)
Responses Re: bytea or blobs?  (Dana Hudes <dhudes@tcp-ip.info>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: CHAR(n) always trims trailing spaces in 7.4
Next
From: Dana Hudes
Date:
Subject: Re: bytea or blobs?