Get table/field-identifiers in uppercase

Поиск
Список
Период
Сортировка
От Klaus Reger
Тема Get table/field-identifiers in uppercase
Дата
Msg-id 200107040906.f6496ia04203@pc01.reger-clan.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: Re: Backup and Recovery
Следующее
От: Colin Strickland
Дата:
Сообщение: RE: [OT] Any major users of postgresql?