Repost: Get table/field-identifiers in uppercase - Mailing list pgsql-hackers

From Klaus Reger
Subject Repost: Get table/field-identifiers in uppercase
Date
Msg-id 200107100501.f6A51c916087@pc01.reger-clan.de
Whole thread Raw
List pgsql-hackers
Hi all,

because no one noticed my last question, please forgive me this repost, but I 
promised my boss to get an answer to this questions.

Here they are:

When a new table or field is created without quotes, it is assumed to be
case-insensitive. Herefore I have some questions:

- Is it SQL-92-conform to handle >"test"< like >test< without quotes, or
shouldn't it be >test< forced to lowercase?

- Oracle returns this no_matter_what-case_it_is-fields with
uppercase-letters. Is it possible for Postgresql, to imitate this behaviour?

- How is the handling of case-sensitivity handled in the system-catalogs? Is
ther any flag or depends it on the name of the object only?

Thank you very much in advance!

Klaus

-- 
Visit WWWdb at
http://wwwdb.org


pgsql-hackers by date:

Previous
From: Rachit Siamwalla
Date:
Subject: WaitOnLock: error on wakeup
Next
From: Harry Yau
Date:
Subject: Quick Question!