Postgres Pro
Downloads
Home   >   mailing lists

Re: Regarding varchar max length in postgres - Mailing list pgsql-general

From Durgamahesh Manne
Subject Re: Regarding varchar max length in postgres
Date
Msg-id CAJCZkoKaRr3uR+w0+W91N7zmv9XcVmTKjZ0hCMg61s7VxcvkdA@mail.gmail.com
Whole thread Raw
In response to Re: Regarding varchar max length in postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Regarding varchar max length in postgres  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
List pgsql-general
Tree view


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

pgsql-general by date:

Previous
From: Rijo Roy
Date:
Subject: Enabling autovacuum per table
Next
From: Durgamahesh Manne
Date:
Subject: Re: Regarding varchar max length in postgres