python - Maximum size of "TEXT" datatype in postgresql

Question

I am working with python.

I have a field with "text" datatype in postgres. Whenever I try to save a very large string, it throws internal error in python, but if I save the string with a smaller size, it saves it properly.

I don't understand the problem. Is it that there is some maximum limit for entering the characters for "TEXT" datatype?

question from:https://stackoverflow.com/questions/10395975/maximum-size-of-text-datatype-in-postgresql

Answer 1

From the manual:

In any case, the longest possible character string that can be stored is about 1 GB.