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@xxxxxxxxxxx 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?"
