Skip site navigation (1) Skip section navigation (2)

Re: Size of Large objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>,Bianca Oberst <bianca(dot)oberst(at)gmx(dot)de>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Size of Large objects
Date: 2005-07-26 13:18:51
Message-ID: 26937.1122383931@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

pgsql-admin by date

Next:From: Edwin QuijadaDate: 2005-07-26 13:19:28
Subject: RE: [pgsql-es-ayuda] ┬┐Como evitar el "case sensitive"?
Previous:From: Peter EisentrautDate: 2005-07-26 09:42:48
Subject: Re: Size of Large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group