Re: bytea or blobs?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: bytea or blobs?
Дата
Msg-id 200402180944.42239.dev@archonet.com
обсуждение исходный текст
Ответ на Re: bytea or blobs?  (Dana Hudes <dhudes@tcp-ip.info>)
Ответы Re: bytea or blobs?  (Dana Hudes <dhudes@tcp-ip.info>)
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: CHAR(n) always trims trailing spaces in 7.4
Следующее
От: Dana Hudes
Дата:
Сообщение: Re: bytea or blobs?