Search Postgresql Archives

Re: Regarding varchar max length in postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Mon, Oct 15, 2018 at 3:11 PM Thomas Kellerer <spam_eater@xxxxxxx> wrote:
Durgamahesh Manne schrieb am 15.10.2018 um 11:18:
> 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
> |text|variable unlimited length

It "text" type is a "character string" just like all the other character types and thus is also limited to 1GB

"text", "varchar", "character varying" and "character" are all identical in how they are stored and processed.

Thomas


Thank you for this information 



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux