Re: Regarding varchar max length in postgres

2018-10-16 Thread Durgamahesh Manne
On Mon, Oct 15, 2018 at 9:52 PM Adrian Klaver wrote: > On 10/15/18 8:56 AM, Durgamahesh Manne wrote: > > > > I request you all community members to provide built in bdr v3 version > > replication for public as multimaster replication is on high priority > > against other dbms > > BDR v3 is thir

Re: Regarding varchar max length in postgres

2018-10-15 Thread Adrian Klaver
On 10/15/18 8:56 AM, Durgamahesh Manne wrote:  I request you all community members to provide built in bdr v3 version replication for public as multimaster replication is on high priority against other dbms BDR v3 is third party extension from 2ndQuadrant, it is not community code. Elemen

Re: Regarding varchar max length in postgres

2018-10-15 Thread Adrian Klaver
On 10/15/18 8:56 AM, Durgamahesh Manne wrote: On Mon, Oct 15, 2018 at 9:07 PM David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Mon, Oct 15, 2018 at 8:24 AM Durgamahesh Manne mailto:maheshpostgr...@gmail.com>> wrote: So i need unlimited length data type for req

Re: Regarding varchar max length in postgres

2018-10-15 Thread Durgamahesh Manne
On Mon, Oct 15, 2018 at 9:07 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Oct 15, 2018 at 8:24 AM Durgamahesh Manne < > maheshpostgr...@gmail.com> wrote: > >> So i need unlimited length data type for required column of the table for >> storing the large values >> is there an

Re: Regarding varchar max length in postgres

2018-10-15 Thread David G. Johnston
On Mon, Oct 15, 2018 at 8:24 AM Durgamahesh Manne wrote: > So i need unlimited length data type for required column of the table for > storing the large values > is there any issue to use unlimited length datatype text for the > required column of the table instead of using varchar ? > Between

Re: Regarding varchar max length in postgres

2018-10-15 Thread Durgamahesh Manne
On Mon, Oct 15, 2018 at 7:54 PM Tom Lane wrote: > Durgamahesh Manne writes: > >>> 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 > > You're confusing the size of string that can be

Re: Regarding varchar max length in postgres

2018-10-15 Thread Tom Lane
Durgamahesh Manne writes: >>> 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 You're confusing the size of string that can be stored with the largest value accepted for "n" in "varchar(n)

Re: Regarding varchar max length in postgres

2018-10-15 Thread Durgamahesh Manne
On Mon, Oct 15, 2018 at 3:11 PM Thomas Kellerer 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 > da

Re: Regarding varchar max length in postgres

2018-10-15 Thread Thomas Kellerer
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|/)|vari

Re: Regarding varchar max length in postgres

2018-10-15 Thread Laurenz Albe
Durgamahesh Manne wrote: > 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

Re: Regarding varchar max length in postgres

2018-10-15 Thread Durgamahesh Manne
On Mon, Oct 15, 2018 at 2:42 PM Durgamahesh Manne wrote: > > > On Mon, Oct 15, 2018 at 2:35 PM Durgamahesh Manne < > maheshpostgr...@gmail.com> wrote: > >> >> >> On Mon, Oct 15, 2018 at 2:32 PM Durgamahesh Manne < >> maheshpostgr...@gmail.com> wrote: >> >>> >>> >>> On Fri, Oct 5, 2018 at 8:55 PM

Re: Regarding varchar max length in postgres

2018-10-15 Thread Durgamahesh Manne
On Mon, Oct 15, 2018 at 2:35 PM Durgamahesh Manne wrote: > > > 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 >> wrote: >> >>> On 10/5/18 8:18 AM, Durgamahesh Manne wrote: >>> > Hi >>> > >>> > please

Re: Regarding varchar max length in postgres

2018-10-15 Thread Thomas Kellerer
Durgamahesh Manne schrieb am 15.10.2018 um 11:05: > 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 > >  H

Re: Regarding varchar max length in postgres

2018-10-15 Thread Durgamahesh Manne
On Mon, Oct 15, 2018 at 2:32 PM Durgamahesh Manne wrote: > > > On Fri, Oct 5, 2018 at 8:55 PM Adrian Klaver > 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/stati

Re: Regarding varchar max length in postgres

2018-10-15 Thread Durgamahesh Manne
On Fri, Oct 5, 2018 at 8:55 PM Adrian Klaver 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 Mann

Re: Regarding varchar max length in postgres

2018-10-05 Thread Adrian Klaver
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

Regarding varchar max length in postgres

2018-10-05 Thread Durgamahesh Manne
Hi please let me know the max length of varchar & text in postgres Regards Durgamahesh Manne