Re: Default size limit for 'character varying' in - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Default size limit for 'character varying' in
Date
Msg-id 1123172230.30036.26.camel@state.g2switchworks.com
Whole thread Raw
In response to Default size limit for 'character varying' in Postgres 8?  (Benjamin Scherrey <scherrey@proteus-tech.com>)
List 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.

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: DNS vs /etc/hosts
Next
From: Gregory Youngblood
Date:
Subject: Re: DNS vs /etc/hosts