CODEWITHSUNDEEP
pythonpostgresql
user977933
user977933

Reputation: 517

Maximum size of "TEXT" datatype in postgresql

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?

Upvotes: 43

Views: 55960

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 127086

From the manual:

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

Upvotes: 70

Related Questions