Re: quoted identifier behaviour

Thomas Kellerer wrote:
> Randall Smith wrote on 14.03.2007 18:59:
>> I'm trying to get Postgresql to work with software that uses JDBC and
>> Oracle for a large government project. So I have to report that the
>> application won't work with Postgresql because it (PG) doesn't adhere
>> to the standard. That's usually something I say about Oracle and
>> MySQL. I'm an advocate of Postgresql and usually tout SQL compliance
>> as a strength, so it bothers me that this is not in line to be corrected.
>
> Then the software is not written well :)
>
> DatabaseMetaData.storesLowerCaseIdentifiers() correctly tells the
> program that PG stores everything in lowercase. So if a (JDBC based)
> software wants to be truly multi-DBMS enabled, it *has* to retrieve
> those things from the driver.
>
> Thomas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

I don't write Java software so I can't discuss what you said. However,
the SQL the app sends IS SQL compliant and Postgresql is not. A table
named foo should be accessible as both foo and "FOO" according to the
standard.

Randall