pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSize of Large objects
6+ messages / 4 participants
[nested] [flat]
* Size of Large objects
@ 2005-07-26 06:37 Bianca Oberst <bianca.oberst@gmx.de>
2005-07-26 07:47 ` Re: Size of Large objects Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Bianca Oberst @ 2005-07-26 06:37 UTC (permalink / raw)
To: pgsql-admin
Hello,
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?
Thank you,
Bianca
--
5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail
+++ GMX - die erste Adresse f�r Mail, Message, More +++
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of Large objects
2005-07-26 06:37 Size of Large objects Bianca Oberst <bianca.oberst@gmx.de>
@ 2005-07-26 07:47 ` Peter Eisentraut <peter_e@gmx.net>
2005-07-26 07:55 ` Re: Size of Large objects Jim C. Nasby <decibel@decibel.org>
2005-07-26 08:42 ` Re: Size of Large objects Bianca Oberst <bianca.oberst@gmx.de>
0 siblings, 2 replies; 6+ messages in thread
From: Peter Eisentraut @ 2005-07-26 07:47 UTC (permalink / raw)
To: Bianca Oberst <bianca.oberst@gmx.de>; +Cc: pgsql-admin
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/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of Large objects
2005-07-26 06:37 Size of Large objects Bianca Oberst <bianca.oberst@gmx.de>
2005-07-26 07:47 ` Re: Size of Large objects Peter Eisentraut <peter_e@gmx.net>
@ 2005-07-26 07:55 ` Jim C. Nasby <decibel@decibel.org>
2005-07-26 09:42 ` Re: Size of Large objects Peter Eisentraut <peter_e@gmx.net>
1 sibling, 1 reply; 6+ messages in thread
From: Jim C. Nasby @ 2005-07-26 07:55 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Bianca Oberst <bianca.oberst@gmx.de>; pgsql-admin
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?"
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of Large objects
2005-07-26 06:37 Size of Large objects Bianca Oberst <bianca.oberst@gmx.de>
2005-07-26 07:47 ` Re: Size of Large objects Peter Eisentraut <peter_e@gmx.net>
2005-07-26 07:55 ` Re: Size of Large objects Jim C. Nasby <decibel@decibel.org>
@ 2005-07-26 09:42 ` Peter Eisentraut <peter_e@gmx.net>
2005-07-26 13:18 ` Re: Size of Large objects Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2005-07-26 09:42 UTC (permalink / raw)
To: Jim C. Nasby <decibel@decibel.org>; +Cc: Bianca Oberst <bianca.oberst@gmx.de>; pgsql-admin
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.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of Large objects
2005-07-26 06:37 Size of Large objects Bianca Oberst <bianca.oberst@gmx.de>
2005-07-26 07:47 ` Re: Size of Large objects Peter Eisentraut <peter_e@gmx.net>
2005-07-26 07:55 ` Re: Size of Large objects Jim C. Nasby <decibel@decibel.org>
2005-07-26 09:42 ` Re: Size of Large objects Peter Eisentraut <peter_e@gmx.net>
@ 2005-07-26 13:18 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2005-07-26 13:18 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Jim C. Nasby <decibel@decibel.org>; Bianca Oberst <bianca.oberst@gmx.de>; pgsql-admin
Peter Eisentraut <peter_e@gmx.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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Size of Large objects
2005-07-26 06:37 Size of Large objects Bianca Oberst <bianca.oberst@gmx.de>
2005-07-26 07:47 ` Re: Size of Large objects Peter Eisentraut <peter_e@gmx.net>
@ 2005-07-26 08:42 ` Bianca Oberst <bianca.oberst@gmx.de>
1 sibling, 0 replies; 6+ messages in thread
From: Bianca Oberst @ 2005-07-26 08:42 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin
Okay, thanks!
Bianca
> --- Ursprüngliche Nachricht ---
> Von: Peter Eisentraut <peter_e@gmx.net>
> An: "Bianca Oberst" <bianca.oberst@gmx.de>
> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2005-07-26 13:18 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-26 06:37 Size of Large objects Bianca Oberst <bianca.oberst@gmx.de>
2005-07-26 07:47 ` Peter Eisentraut <peter_e@gmx.net>
2005-07-26 07:55 ` Jim C. Nasby <decibel@decibel.org>
2005-07-26 09:42 ` Peter Eisentraut <peter_e@gmx.net>
2005-07-26 13:18 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-07-26 08:42 ` Bianca Oberst <bianca.oberst@gmx.de>
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