what is maximum size of "text" datatype in postgres?

Поиск
Список
Период
Сортировка
От Smit
Тема what is maximum size of "text" datatype in postgres?
Дата
Msg-id 20040913083554.9110.qmail@web53107.mail.yahoo.com
обсуждение исходный текст
Список pgsql-sql
Hi,

i wanted to know, what is maximum size of "text"
datatype in postgres.
It is given as "unlimited characters" in the postgres
documentation. 
But it doesn't store characters more than 5000. The
connection get lost if i tried to store more than 5000
characters.

I had read somewhere on forum that its max limit is 8
bytes, and we can increase it to 32 bytes.

Do any one know how to increse it? 
or do anyone know any other way to solve this problem.

Thanks,
Smita

    
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun!
http://uk.messenger.yahoo.com
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: create unique index schema.index_name on table (column)?
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: what is maximum size of "text" datatype in postgres?