Re: putting binary data in a char field?

Поиск
Список
Период
Сортировка
От Ron Snyder
Тема Re: putting binary data in a char field?
Дата
Msg-id D486606E7AD20947BDB7E56862E04C39474FAD@cvo1.cvo.roguewave.com
обсуждение исходный текст
Ответ на putting binary data in a char field?  (Ron Snyder <snyder@roguewave.com>)
Список pgsql-general
> You should also experiment with using a TEXT field and base64
> encoding to insert data and base64 decoding to select data.
> In my experience, this is faster than using a bytea field.
> Certain characters in binary data have to be escaped properly
> before you can insert data.  The size and time this takes can
> vary.  Base64 encoding is fast and will increase the binary
> string by 1/3.

Hmm, I may give that a try.  Thanks,

-ron

В списке pgsql-general по дате отправления:

Предыдущее
От: tfo@alumni.brown.edu (Thomas F. O'Connell)
Дата:
Сообщение: pg_dump out of shared memory
Следующее
От: Adam Smith
Дата:
Сообщение: PostgresSQL 7.3.x removal