Upper limit of a TEXT field

Started by Dale Andersonover 25 years ago2 messages
#1Dale Anderson
danderso@crystalsugar.com

I have been looking at all of the online docs, and I can't find it, or just didn't see it. What is the max length string than can be stored in a TEXT field. I am running v7.0.2 on RedHat 6.2

Thanks,
Dale.

#2Lamar Owen
lamar.owen@wgcr.org
In reply to: Dale Anderson (#1)
Re: Upper limit of a TEXT field

Dale Anderson wrote:

I have been looking at all of the online docs, and I can't find it, or just didn't see it. What is the max length string than can be stored in a TEXT field. I am running v7.0.2 on RedHat 6.2

Assuming the RPM postgresql and no BLKSZ trickery, a little less than
8K.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11