TEXT field's length limit in PostgreSQL

From: Michał 'Samuel' Modestowicz <samuel(at)netmagia(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: TEXT field's length limit in PostgreSQL
Date: 2001-10-18 06:48:07
Message-ID: 004f01c157a0$e310d6c0$3f6c63d9@default
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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(at)netmagia(dot)pl .

Thx in advance,
Michael 'Samuel' Modestowicz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J C Lawrence 2001-10-18 07:10:22 Re: COMMIT after an ERROR?
Previous Message Hiroshi Inoue 2001-10-18 06:21:08 Re: To Postgres Devs : Wouldn't changing the select limit