Re: Default size limit for 'character varying' in

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Default size limit for 'character varying' in
Дата
Msg-id 1123172230.30036.26.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Default size limit for 'character varying' in Postgres 8?  (Benjamin Scherrey <scherrey@proteus-tech.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: DNS vs /etc/hosts
Следующее
От: Gregory Youngblood
Дата:
Сообщение: Re: DNS vs /etc/hosts