Max size for varchar(n) data type

[Carmen Wai]

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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Kris Jurka]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly