Re: VARCHAR vs TEXT

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: VARCHAR vs TEXT
Date: 2001-10-16 14:08:11
Message-ID: 15308.16203.511887.66643@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>>>>> "BM" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:

>> Could you add the length limitation for TEXT to the reference manual?
>> I searched high and low for that limit, but never found it. Also,
>> what's the max VARCHAR() or CHAR() I can create? Is that also 1Gb?

BM> TEXT limit is 1GB, as shown on the 'limits' FAQ item. Is it worth
BM> mentioning here? CHAR()/VARCHAR() also 1GB limit.

My personal belief is that most FAQ entries could go away if the
reference documentation had the necessary information...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Bax 2001-10-16 15:46:43 Re: VARCHAR vs TEXT
Previous Message Vince Vielhaber 2001-10-16 14:07:07 Re: Why are ftp mirrors out of sync?