Re: Regarding varchar max length in postgres

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org, andreas(at)a-kretschmer(dot)de
Subject: Re: Regarding varchar max length in postgres
Date: 2018-10-15 09:02:31
Message-ID: CAJCZkoKaRr3uR+w0+W91N7zmv9XcVmTKjZ0hCMg61s7VxcvkdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 5, 2018 at 8:55 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com

Hi

Thank you for this information

as per the postgresql documentation

If character varying is used without length specifier, the type accepts
strings of any size

but varchar does not accept more than this

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durgamahesh Manne 2018-10-15 09:05:11 Re: Regarding varchar max length in postgres
Previous Message Rijo Roy 2018-10-15 08:01:20 Enabling autovacuum per table