Postgres Pro
Downloads
Home   >   mailing lists

what is maximum size of "text" datatype in postgres? - Mailing list pgsql-sql

From Smit
Subject what is maximum size of "text" datatype in postgres?
Date
Msg-id 20040913083554.9110.qmail@web53107.mail.yahoo.com
Whole thread Raw
List pgsql-sql
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: create unique index schema.index_name on table (column)?
Next
From: Christopher Browne
Date:
Subject: Re: what is maximum size of "text" datatype in postgres?