Thread: Max size for varchar(n) data type

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

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