X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4E3EC329E15
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 13 Sep 2004 09:36:00 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 95002-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 13 Sep 2004 08:35:54 +0000 (GMT)
Received: from web53107.mail.yahoo.com (web53107.mail.yahoo.com
	[206.190.39.210])
	by svr1.postgresql.org (Postfix) with SMTP id A6724329E2E
	for <pgsql-sql@postgresql.org>; Mon, 13 Sep 2004 09:35:54 +0100 (BST)
Message-ID: <20040913083554.9110.qmail@web53107.mail.yahoo.com>
Received: from [203.124.129.109] by web53107.mail.yahoo.com via HTTP;
	Mon, 13 Sep 2004 09:35:54 BST
Date: Mon, 13 Sep 2004 09:35:54 +0100 (BST)
From: "Smit" <smitamarda@yahoo.co.uk>
Subject: what is maximum size of "text" datatype in postgres?
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200409/93
X-Sequence-Number: 18939

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