Re: quoted identifier behaviour - Mailing list pgsql-general

From Albe Laurenz
Subject Re: quoted identifier behaviour
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB201B4AE1A@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to 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.
>>
>> You must not change the names of system tables, but you can
>> certainly create upper case views for them.
>
> That's my current solution.  I imagine this is not very
> efficient, but I could be wrong.

I think that the performance impact is negligible.
The pain is to maintain the views - the catalog tables can
change in every new release...

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Chris Coleman"
Date:
Subject: Re: Plperl Question
Next
From: "Albe Laurenz"
Date:
Subject: Re: database locks