Re: capacity of datatype "text" - Mailing list pgsql-general

From Neil Conway
Subject Re: capacity of datatype "text"
Date
Msg-id 1098160173.1113.123.camel@localhost.localdomain
Whole thread Raw
In response to capacity of datatype "text"  (johnossmann@yahoo.com (John Ossmann))
List pgsql-general
On Wed, 2004-10-13 at 14:58, John Ossmann wrote:
> I'm not sure where to find it exactly, but does anyone know how much
> data a column of type "text" in a postgres DB can hold?

There is no limit on what "text" itself can contain. However, a field of
any data type can contain at most 1GB (compressed -- Postgres will do
this compression automatically). See:

http://www.postgresql.org/docs/faqs/FAQ.html#4.5

-Neil



pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Numeric user names
Next
From: David Garamond
Date:
Subject: Re: capacity of datatype "text"