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

From Klaus Reger
Subject Get table/field-identifiers in uppercase
Date
Msg-id 200107040906.f6496ia04203@pc01.reger-clan.de
Whole thread Raw
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Re: Backup and Recovery
Next
From: Colin Strickland
Date:
Subject: RE: [OT] Any major users of postgresql?