Max size for varchar(n) data type

Started by Carmen Waiover 21 years ago2 messagesgeneral
Jump to latest
#1Carmen 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

#2Kris Jurka
books@ejurka.com
In reply to: Carmen Wai (#1)
Re: Max size for varchar(n) data type

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