How Do I Toggle Quoted Identifiers?

From: googlemike(at)hotpop(dot)com (Google Mike)
To: pgsql-sql(at)postgresql(dot)org
Subject: How Do I Toggle Quoted Identifiers?
Date: 2003-12-04 19:42:56
Message-ID: 25d8d6a8.0312041142.6ac4a5cd@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-12-04 20:45:20 Re: How Do I Toggle Quoted Identifiers?
Previous Message Jeff Kowalczyk 2003-12-04 19:24:29 Re: Trigger plpgsql function, how to test if OLD is set?