Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity - Mailing list pgsql-sql

On Fri, Oct 14, 2011 at 01:51:04PM -0400, Adam Cornett wrote:
> On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas <TGood@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