On Mon, Oct 15, 2018 at 3:11 PM Thomas Kellerer <spam_ea...@gmx.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 > > >
