Re: Regarding varchar max length in postgres

On Mon, Oct 15, 2018 at 3:11 PM Thomas Kellerer <spam_eater(at)gmx(dot)net> 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
>
>
>