Search Postgresql Archives

Re: quoted identifier behaviour

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux