X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 555D3D1B4C1 for ; Thu, 4 Dec 2003 19:59:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08466-07 for ; Thu, 4 Dec 2003 15:59:14 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 51ED9D1B4A7 for ; Thu, 4 Dec 2003 15:58:20 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id hB4JwKbI052506 for ; Thu, 4 Dec 2003 19:58:20 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hB4JgvF1050406 for pgsql-sql@postgresql.org; Thu, 4 Dec 2003 19:42:57 GMT From: googlemike@hotpop.com (Google Mike) X-Newsgroups: comp.databases.postgresql.sql Subject: How Do I Toggle Quoted Identifiers? Date: 4 Dec 2003 11:42:56 -0800 Organization: http://groups.google.com Lines: 14 Message-ID: <25d8d6a8.0312041142.6ac4a5cd@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/41 X-Sequence-Number: 16207 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? Quoted identifiers, as I understand them, are where you must put double quotes around any table or column name in order to preserve its case, or in order to preserve an internal space it may have in the identifier name. I was looking for something like: SET QUOTED_IDENTIFIERS = OFF; SELECT Username FROM Logins; For that matter, how do I turn case-sensitivity off?