Re: Max size for varchar(n) data type - Mailing list pgsql-general

From Kris Jurka
Subject Re: Max size for varchar(n) data type
Date
Msg-id Pine.BSO.4.56.0407160439220.4736@leary.csoft.net
Whole thread Raw
In response to Max size for varchar(n) data type  ("Carmen Wai" <wai_carmen@hotmail.com>)
List pgsql-general

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

pgsql-general by date:

Previous
From: "Carmen Wai"
Date:
Subject: Max size for varchar(n) data type
Next
From: "Dylan Milks"
Date:
Subject: Insert images through ASP