TOAST and TEXT

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема TOAST and TEXT
Дата
Msg-id 3BC3A550.9060809@bitmead.com
обсуждение исходный текст
Ответы Re: TOAST and TEXT  (Marko Kreen <marko@l-t.ee>)
Re: TOAST and TEXT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

Now that postgresql doesn't have field size limits, it seems to
me they should be good for storing large blobs, even if it means
having to uuencode them to be non-binary or whatever. I don't
like the old large object implementation, I need to store very large
numbers of objects and unless this implementation has changed
in recent times it won't cut it.

So my question is, I assume TEXT is the best data type to store
large things in, what precisely is the range of characters that
I can store in TEXT? Is it only characters ascii <= 127, or is
it only printable characters, or everything except '\0' or what?



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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: row value constructor bug?
Следующее
От: "Rod Taylor"
Дата:
Сообщение: Re: TOAST and TEXT