Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity

On Fri, Oct 14, 2011 at 2:09 PM, ktm(at)rice(dot)edu <ktm(at)rice(dot)edu> wrote:

> 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(at)svwsjmc(dot)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
>

Yes, 1GB is the limit for any column size. From what I can tell a varchar
without a size specified acts just like text.

-Adam