From: ktm@rice.edu <ktm@rice.edu>
To: Adam Cornett <adam.cornett@gmail.com>
Cc: Good, Thomas <TGood@svwsjmc.org>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity
Date: Fri, 14 Oct 2011 13:09:19 -0500
Message-ID: <20111014180919.GY10975@staff-mud-56-27.rice.edu> (raw)
In-Reply-To: <CAB5sPxb7HotxjE9J-6hU6+hYy1RtOjQevUSfzdHGunZLW72DGw@mail.gmail.com>
References: <C3FA421FEED237488E9820D1ED668F330AB5ACE3@SVWEMAIL>
<CAB5sPxb7HotxjE9J-6hU6+hYy1RtOjQevUSfzdHGunZLW72DGw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ktm@rice.edu, adam.cornett@gmail.com, TGood@svwsjmc.org
Subject: Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity
In-Reply-To: <20111014180919.GY10975@staff-mud-56-27.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox