Re: Size of Large objects

On Tue, Jul 26, 2005 at 09:47:33AM +0200, Peter Eisentraut wrote:
> Am Dienstag, 26. Juli 2005 08:37 schrieb Bianca Oberst:
> > I'm new in postgres. I searched the archives, but I don't find an answer.
> > So can anybody tell me the explicit size, which a clob or a blob can have
> > in postgres 8.0?
>
> Columns can contain up to 1 GB of data.  The terms clob or blob are not used
> in PostgreSQL; the limitation is the same on all column types.

Not entirely true...

decibel=# select version();
 PostgreSQL 8.0.3 on powerpc-apple-darwin7.9.0, compiled by GCC gcc
 (GCC) 3.3 20030304 (Apple Computer, Inc. build 1495)

 decibel=# create table t(v varchar(1000000000));
 ERROR:  length for type varchar cannot exceed 10485760
 decibel=#
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"