Re: TEXT field's length limit in PostgreSQL

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re: TEXT field's length limit in PostgreSQL
Дата
Msg-id Pine.LNX.4.30.0110180944460.4403-100000@chapelperilous.net
обсуждение исходный текст
Ответ на TEXT field's length limit in PostgreSQL  ("Michał 'Samuel' Modestowicz" <samuel@netmagia.pl>)
Список pgsql-general
On Thu, 18 Oct 2001, [iso-8859-2] Micha³ 'Samuel' Modestowicz wrote:

> I know that my question may seem trivial, but unfortunately I haven't found
> any understandable info on this topic. It's about length limit of the TEXT
> field in PostgreSQL. I've heard that the TEXT fields in psql are limited to
> 4096 bytes but it's just unbelievable for me. So if I've got text of more
> than 4096 bytes size, for example article - do I really have to put it in
> the LOB field and use these terrific lo-functions to access it ?? Please, if
> anyone can help me - write to samuel@netmagia.pl .

The limitation is gone in 7.1.  According to the documentation, the length
is unlimited.  Realistically, I think sizes of around 1G are the discrete
limit.

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
Even moderation ought not to be practiced to excess.


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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: sql scripts and other questions.
Следующее
От: qk22@gmx.co.uk (qk22)
Дата:
Сообщение: Can not input large text data