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

From David Garamond
Subject Re: capacity of datatype "text"
Date
Msg-id 4174A2CD.9000305@zara.6.isreserved.com
Whole thread Raw
In response to capacity of datatype "text"  (johnossmann@yahoo.com (John Ossmann))
Responses Re: capacity of datatype "text"  (John DeSoi <desoi@pgedit.com>)
List pgsql-general
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?

it's in the manual, in the Data Types section. the manual says "around 1GB".

btw, TEXT is one of those postgres-specific features that makes you
stick (stuck? :-) with postgres. nowadays, i never ever have to bother
to think whether to give a column a max width of 32, 50, 64, 100, 150,
... is that a bad thing?

--
dave

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: capacity of datatype "text"
Next
From: Aaron Glenn
Date:
Subject: Re: clustering