Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D9EEFB5DC31 for ; Fri, 14 Oct 2011 15:16:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 35617-05 for ; Fri, 14 Oct 2011 18:16:42 +0000 (UTC) X-Greylist: delayed 00:07:19.831967 by SQLgrey-1.8.0-rc2 Received: from mh5.mail.rice.edu (mh5.mail.rice.edu [128.42.199.32]) by mail.postgresql.org (Postfix) with ESMTP id 3F5EBB5DC3D for ; Fri, 14 Oct 2011 15:16:42 -0300 (ADT) Received: from mh5.mail.rice.edu (localhost.localdomain [127.0.0.1]) by mh5.mail.rice.edu (Postfix) with ESMTP id 5D5A5290DD7; Fri, 14 Oct 2011 13:09:20 -0500 (CDT) X-Virus-Scanned: by amavis-2.6.4 at mh5.mail.rice.edu Received: from mh5.mail.rice.edu ([127.0.0.1]) by mh5.mail.rice.edu (mh5.mail.rice.edu [127.0.0.1]) (amavis, port 10024) with ESMTP id rjOHKEIxgosu; Fri, 14 Oct 2011 13:09:20 -0500 (CDT) X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no Received: from staff-mud-56-27.rice.edu (staff-mud-56-27.rice.edu [168.7.56.27]) by mh5.mail.rice.edu (Postfix) with ESMTP id 1C65E290DC8; Fri, 14 Oct 2011 13:09:20 -0500 (CDT) Received: by staff-mud-56-27.rice.edu (Postfix, from userid 18612) id 09E33740E34; Fri, 14 Oct 2011 13:09:19 -0500 (CDT) Date: Fri, 14 Oct 2011 13:09:19 -0500 From: "ktm@rice.edu" To: Adam Cornett Cc: "Good, Thomas" , "pgsql-sql@postgresql.org" Subject: Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity Message-ID: <20111014180919.GY10975@staff-mud-56-27.rice.edu> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-12-10) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/18 X-Sequence-Number: 35902 On Fri, Oct 14, 2011 at 01:51:04PM -0400, Adam Cornett wrote: > On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas 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