Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 05DF22E35F9 for ; Tue, 11 Dec 2007 13:36:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 82438-06-3 for ; Tue, 11 Dec 2007 13:35:59 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 800622E3831 for ; Tue, 11 Dec 2007 13:30:42 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1J28wM-0005PK-0Y for pgsql-sql@postgresql.org; Tue, 11 Dec 2007 12:30:42 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 0EA3650476; Tue, 11 Dec 2007 12:30:37 -0500 (EST) Date: Tue, 11 Dec 2007 12:30:37 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: case sensitivity for tables, columns, and constraint names Message-ID: <20071211173037.GL27409@crankycanuck.ca> References: <863ECFDF04C8804ABDF3559D87F157C638E5D9@MAGPTCPEXC02.na.mag-ias.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <863ECFDF04C8804ABDF3559D87F157C638E5D9@MAGPTCPEXC02.na.mag-ias.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/48 X-Sequence-Number: 29740 On Tue, Dec 11, 2007 at 11:05:25AM -0600, Ertel, Steve wrote: > is wrapped in quotes. Is there a setting to allow upper case and mixed > case names for database tables, fields, etc, without having to wrap each > in quotes? No, sorry. The always-one-case rule for unquoted identifiers is ANSI conformant. As it happens, the ANSI rule also makes everything ALLCAPS, but PostgreSQL doesn't go that way (for historical reasons). A