pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <decibel@decibel.org>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Bianca Oberst <bianca.oberst@gmx.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Size of Large objects
Date: Tue, 26 Jul 2005 02:55:43 -0500
Message-ID: <20050726075543.GN29346@decibel.org> (raw)
In-Reply-To: <200507260947.33721.peter_e@gmx.net>
References: <3853.1122359862@www10.gmx.net>
	<200507260947.33721.peter_e@gmx.net>

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



view thread (6+ messages)  latest in thread

Message-ID: <20050726075543.GN29346@decibel.org>
Permalink:  ../20050726075543.GN29346@decibel.org/
Also on:    postgresql.org/message-id/20050726075543.GN29346@decibel.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: decibel@decibel.org, peter_e@gmx.net, bianca.oberst@gmx.de
  Subject: Re: Size of Large objects
  In-Reply-To: <20050726075543.GN29346@decibel.org>
  References: <3853.1122359862@www10.gmx.net> <200507260947.33721.peter_e@gmx.net> <20050726075543.GN29346@decibel.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox