Re: Default size limit for 'character varying' in

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Default size limit for 'character varying' in
Date: 2005-08-04 16:17:10
Message-ID: 1123172230.30036.26.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2005-08-04 at 10:57, Benjamin Scherrey wrote:
> In Postgres 8, if a row attribute is defined as 'character varying'
> without specifying a size, what is its size limit? Is it a
> platform-specific/char encoding issue? Is this the same as declaring it
> a 'text' type? I don't find this specified in the documentation.

Approx 1 gig (2^30). The highest limit you can SET if you choose to do
so it 2^20 (1 meg). text and varchar are the same type, inside, by the
way.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Youngblood 2005-08-04 16:18:03 Re: DNS vs /etc/hosts
Previous Message Michael Fuhr 2005-08-04 15:58:05 Re: DNS vs /etc/hosts