X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C807F52894 for ; Tue, 26 Jul 2005 05:42:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41763-09 for ; Tue, 26 Jul 2005 08:42:24 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 6C14E52FCB for ; Tue, 26 Jul 2005 05:42:22 -0300 (ADT) Received: (qmail 13883 invoked by uid 0); 26 Jul 2005 08:42:23 -0000 Received: from 141.66.16.25 by www10.gmx.net with HTTP; Tue, 26 Jul 2005 10:42:23 +0200 (MEST) Date: Tue, 26 Jul 2005 10:42:23 +0200 (MEST) From: "Bianca Oberst" To: Peter Eisentraut Cc: pgsql-admin@postgresql.org MIME-Version: 1.0 References: <200507260947.33721.peter_e@gmx.net> Subject: =?ISO-8859-1?Q?Re:__Size_of_Large_objects?= X-Priority: 3 (Normal) X-Authenticated: #6850045 Message-ID: <25395.1122367343@www10.gmx.net> X-Mailer: WWW-Mail 1.6 (Global Message Exchange) X-Flags: 0001 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/202 X-Sequence-Number: 18258 Okay, thanks! Bianca > --- Ursprüngliche Nachricht --- > Von: Peter Eisentraut > An: "Bianca Oberst" > Kopie: pgsql-admin@postgresql.org > Betreff: Re: [ADMIN] Size of Large objects > Datum: Tue, 26 Jul 2005 09:47:33 +0200 > > 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. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- GMX DSL = Maximale Leistung zum minimalen Preis! 2000 MB nur 2,99, Flatrate ab 4,99 Euro/Monat: http://www.gmx.net/de/go/dsl