Max size for varchar(n) data type

Поиск
Список
Период
Сортировка
Искать

Max size for varchar(n) data type

От:
"Carmen Wai" <wai_carmen@hotmail.com>
Дата:
Hello:

What is the maximum size of varchar(n) for a field in a row in postgresql 
7.2.1?

Thank a lot!
Carmen

_________________________________________________________________
Get 10Mb extra storage for MSN Hotmail. Subscribe Now! 
http://join.msn.com/?pgmarket=en-hk

Re: Max size for varchar(n) data type

От:
Kris Jurka <books@ejurka.com>
Дата:


On Fri, 16 Jul 2004, Carmen Wai wrote:

> What is the maximum size of varchar(n) for a field in a row in postgresql 
> 7.2.1?
> 

The largest n value you can declare is just over 10 million, but you can 
declare column without specifying a length as just varchar and it can hold 
up to a GB, although performance suffers with very large values.

Kris Jurka
FAQ