Postgres Pro
Downloads
Home   >   mailing lists

TEXT field's length limit in PostgreSQL - Mailing list pgsql-general

From Michał 'Samuel' Modestowicz
Subject TEXT field's length limit in PostgreSQL
Date
Msg-id 004f01c157a0$e310d6c0$3f6c63d9@default
Whole thread Raw
Responses Re: TEXT field's length limit in PostgreSQL  ("Dr. Evil" <drevil@sidereal.kz>)
Re: TEXT field's length limit in PostgreSQL  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-general
Tree view 
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@netmagia.pl .

Thx in advance,
Michael 'Samuel' Modestowicz

pgsql-general by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: To Postgres Devs : Wouldn't changing the select limit
Next
From: "Dr. Evil"
Date:
Subject: Re: TEXT field's length limit in PostgreSQL