Durgamahesh Manne wrote:
> was there any specific reason that you have given max length for varchar is limited to 10485760 value?
>
> why you have not given max length for varchar is unlimited like text datatype ?
>
> character varying(n), varchar(n)variable-length with limit
> character(n), char(n)fixed-length, blank padded
> textvariable unlimited length
The data type "text" has the same size limit of 1GB.
"character varying" (without type modifier) and "text" are pretty much
identical.
Since data of these types are loaded into memory when you read them
from or write them to the database, you usually start having problems
long before you reach that limit.
If you want to store huge text files, either store them outside the
database or use Large Objects, which can be read and written in chunks.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com