Is there a maximum length when storing into PostgreSQL TEXT

According to the Postgres character type documentation, text is variable unlimited length.
And further down:

… PostgreSQL provides the text type, which stores strings of any length.


According to the Postgres Wiki, there is a hard limit of 1GB for a single column value, so the practical limit for the “unlimited” length text value is limited to 1GB by the architecture.

Leave a Comment