| From: | Klaus Reger <K(dot)Reger(at)wwwdb(dot)de> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Get table/field-identifiers in uppercase |
| Date: | 2001-07-04 09:06:38 |
| Message-ID: | 200107040906.f6496ia04203@pc01.reger-clan.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colin Strickland | 2001-07-04 09:39:50 | RE: [OT] Any major users of postgresql? |
| Previous Message | Zeugswetter Andreas SB | 2001-07-04 08:37:57 | AW: Re: Backup and Recovery |