Re: Max size for varchar(n) data type

From: Kris Jurka <books(at)ejurka(dot)com>
To: Carmen Wai <wai_carmen(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Max size for varchar(n) data type
Date: 2004-07-16 09:41:51
Message-ID: Pine.BSO.4.56.0407160439220.4736@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dylan Milks 2004-07-16 13:21:30 Insert images through ASP
Previous Message Najib Abi Fadel 2004-07-16 08:03:56 Postgres C functions documentation