From: Richard Huxton <dev@archonet.com>
To: googlemike@hotpop.com (Google Mike), pgsql-sql@postgresql.org
Subject: Re: How Do I Toggle Quoted Identifiers?
Date: Thu, 4 Dec 2003 20:45:20 +0000
User-Agent: KMail/1.5
References: <25d8d6a8.0312041142.6ac4a5cd@posting.google.com>
In-Reply-To: <25d8d6a8.0312041142.6ac4a5cd@posting.google.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200312042045.20911.dev@archonet.com>

On Thursday 04 December 2003 19:42, Google Mike wrote:
> I'm on PHP 4.2.2 and RedHat 9 with PGSQL. I want to turn quoted
> identifiers off with my SQL queries. What SQL statement or .CONF
> setting do I need to change so that I can turn quoted identifiers off?

Short answer - you don't. Your understanding is correct, basically PG will 
lowercase identifiers unless you quote them, in which case you will want to 
use quotes when accessing them. So...

CREATE TABLE AAA ...
CREATE TABLE "BBB" ...
CREATE TABLE "ccc" ...
SELECT * FROM AAA;   -- works
SELECT * FROM aaa;   -- works
SELECT * FROM "AAA"  -- fails
SELECT * FROM BBB;   -- fails
SELECT * FROM "BBB"; -- works
SELECT * FROM CCC;   -- works
SELECT * FROM "ccc"; -- works
SELECT * FROM "CCC"; -- fails

So long as you don't create your identifiers with quotes, you can refer to 
them as upper/lower case. Personally, I create them all lower-case anyway and 
use caps for SQL keywords.

-- 
  Richard Huxton
  Archonet Ltd