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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq