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 [EMAIL PROTECTED] .
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