On Mon, Oct 15, 2018 at 2:32 PM Durgamahesh Manne <maheshpostgr...@gmail.com> wrote:
> > > On Fri, Oct 5, 2018 at 8:55 PM Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> On 10/5/18 8:18 AM, Durgamahesh Manne wrote: >> > Hi >> > >> > please let me know the max length of varchar & text in postgres >> >> https://www.postgresql.org/docs/10/static/datatype-character.html >> > >> > >> > >> > Regards >> > >> > Durgamahesh Manne >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com > > > Hi > > Thank you for this information > > as per the postgresql documentation please ignore incomplete message i > mailed to respected community members > > If character varying is used without length specifier, the type accepts > strings of any size > > but varchar does not accept more than this 10485760 value > create table test(id serial primary key, str varchar(10485761)); ERROR: length for type varchar cannot exceed 10485760