On Fri, Oct 14, 2011 at 01:51:04PM -0400, Adam Cornett wrote: > On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas <tg...@svwsjmc.org> wrote: > > > I created a table in a hurry and forgot to specify the max capacity for a > > varchar() data type. > > Can it be said what the max would be in a case like this (just curious)? > > > > thanks much > > > > According to > http://www.postgresql.org/docs/current/static/datatype-character.html, > "If character varying is used without length specifier, the type accepts > strings of any size. The latter is a PostgreSQL extension." > > -Adam Cornett
And according to the documentation, the maximum size of a varchar is 1GB. Regards, Ken -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql