Re: quoted identifier behaviour - Mailing list pgsql-general

From Albe Laurenz
Subject Re: quoted identifier behaviour
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB201B0A23E@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to quoted identifier behaviour  (Randall Smith <randall@tnr.cc>)
Responses Re: quoted identifier behaviour  (Randall Smith <randall@tnr.cc>)
List pgsql-general
Randall Smith wrote:
> Are there plans to make Postgresql's behavior SQL compliant with
regards
> to quoted identifiers?  My specific need is to access tables named in
> lower case by an uppercase quoted identifier, which is in line with
the
> SQL standard.  So if I created table foo, I should be able to access
it
> like "FOO".  Is there a configuration options that modifies this
> behavior or can I change the names in the system tables?

I don't think that there are plans to change this as it would be
hard to maintain compatibility.

You must not change the names of system tables, but you can
certainly create upper case views for them.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: quoted identifier behaviour
Next
From: Walter Vaughan
Date:
Subject: Re: DST problem on Windows Server