Skip site navigation (1) Skip section navigation (2)

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

From: "Smit" <smitamarda(at)yahoo(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: what is maximum size of "text" datatype in postgres?
Date: 2004-09-13 08:35:54
Message-ID: 20040913083554.9110.qmail@web53107.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-sql by date

Next:From: Christopher BrowneDate: 2004-09-13 09:31:30
Subject: Re: what is maximum size of "text" datatype in postgres?
Previous:From: m├śntar3Date: 2004-09-12 20:33:38
Subject: Re: create unique index schema.index_name on table (column)?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group