On Fri, Oct 14, 2011 at 2:09 PM, k...@rice.edu <k...@rice.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 <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 > 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
