Re: Size of Large objects - Mailing list pgsql-admin

From Tom Lane
Subject Re: Size of Large objects
Date
Msg-id 26937.1122383931@sss.pgh.pa.us
Whole thread Raw
In response to Re: Size of Large objects  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Peter Eisentraut <peter_e@gmx.net> writes:
> Am Dienstag, 26. Juli 2005 09:55 schrieb Jim C. Nasby:
>> decibel=# create table t(v varchar(1000000000));
>> ERROR:  length for type varchar cannot exceed 10485760

> The length you can declare and the size you can store (if a length declaration
> doesn't stop you) are, for various uninteresting reasons, not related.

Also, you can just say "varchar" with no specific length limit, which is
then more or less equivalent to "text".

            regards, tom lane

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Size of Large objects
Next
From: Kailash Vyas
Date:
Subject: postgres performance optimization