Search Postgresql Archives

Re: Default size limit for 'character varying' in

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux