Re: TEXT field's length limit in PostgreSQL

Take a look at www.postgresql.org/docs/index.php?datatype-character.html. Be
sure to take a look at the comments at the bottom of the page. The
documentation agrees with you, but Peter Eisentraut gives a different take.

 -----Original Message-----
From:     Brett W. McCoy [mailto:bmccoy@chapelperilous.net]
Sent:    Thursday, October 18, 2001 6:50 AM
To:    Michal 'Samuel' Modestowicz
Cc:    pgsql-general@postgresql.org
Subject:    Re: [GENERAL] TEXT field's length limit in PostgreSQL

On Thu, 18 Oct 2001, [iso-8859-2] Micha³ 'Samuel' Modestowicz wrote:

> I know that my question may seem trivial, but unfortunately I haven't
found
> any understandable info on this topic. It's about length limit of the TEXT
> field in PostgreSQL. I've heard that the TEXT fields in psql are limited
to
> 4096 bytes but it's just unbelievable for me. So if I've got text of more
> than 4096 bytes size, for example article - do I really have to put it in
> the LOB field and use these terrific lo-functions to access it ?? Please,
if
> anyone can help me - write to samuel@netmagia.pl .

The limitation is gone in 7.1.  According to the documentation, the length
is unlimited.  Realistically, I think sizes of around 1G are the discrete
limit.

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
Even moderation ought not to be practiced to excess.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html