Re: capacity of datatype "text"

From: Neil Conway <neilc(at)samurai(dot)com>
To: John Ossmann <johnossmann(at)yahoo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: capacity of datatype "text"
Date: 2004-10-19 04:29:33
Message-ID: 1098160173.1113.123.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-10-19 05:14:53 Re: capacity of datatype "text"
Previous Message Neil Conway 2004-10-19 04:25:13 Re: Numeric user names