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 > > 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 Further down on that page the overall limit is documented: In any case, the longest possible character string that can be stored is about 1 GB So the part that you quoted implicitly means "accepts strings of any size - up to the maximum of 1GB" Maybe it makes sense to make that clearer at that point. Regards Thomas
