| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "Randall Smith *EXTERN*" <randall(at)tnr(dot)cc>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: quoted identifier behaviour |
| Date: | 2007-03-14 17:36:50 |
| Message-ID: | AFCCBB403D7E7A4581E48F20AF3E5DB201B0A23E@EXADV1.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Walter Vaughan | 2007-03-14 17:49:03 | Re: DST problem on Windows Server |
| Previous Message | Ashley Moran | 2007-03-14 17:25:16 | How to write a function that manipulates a set of results |