Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F28532E317A for ; Tue, 11 Dec 2007 13:39:53 -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 84130-01-8 for ; Tue, 11 Dec 2007 13:39:48 -0400 (AST) Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132]) by postgresql.org (Postfix) with ESMTP id 84F492E35DA for ; Tue, 11 Dec 2007 13:35:11 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay05.plus.net with esmtp (Exim) id 1J290e-0001ah-0c; Tue, 11 Dec 2007 17:35:08 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id EDAB4274046; Tue, 11 Dec 2007 17:35:06 +0000 (GMT) Message-ID: <475ECA4A.5060300@archonet.com> Date: Tue, 11 Dec 2007 17:35:06 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: "Ertel, Steve" CC: pgsql-sql@postgresql.org Subject: Re: case sensitivity for tables, columns, and constraint names References: <863ECFDF04C8804ABDF3559D87F157C638E5D9@MAGPTCPEXC02.na.mag-ias.net> In-Reply-To: <863ECFDF04C8804ABDF3559D87F157C638E5D9@MAGPTCPEXC02.na.mag-ias.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/49 X-Sequence-Number: 29741 Ertel, Steve wrote: > I see that I can create a table with a mixed case name as long as the > name 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, SQL defines identifiers as case-insensitive. PG is unusual in that left alone it folds names to lower-case rather than upper, but all SQL databases (afaik) are case-insensitive by default. -- Richard Huxton Archonet Ltd