Re: capacity of datatype "text"

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: John Ossmann <johnossmann(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: capacity of datatype "text"
Date: 2004-10-19 05:14:53
Message-ID: 4174A2CD.9000305@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aaron Glenn 2004-10-19 05:39:12 Re: clustering
Previous Message Neil Conway 2004-10-19 04:29:33 Re: capacity of datatype "text"