Get table/field-identifiers in uppercase

Hi all,

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