Thread: Default size limit for 'character varying' in Postgres 8?

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.

    thanx & later,

       Ben Scherrey

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.