Skip site navigation (1) Skip section navigation (2)

Get table/field-identifiers in uppercase

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: (view raw, whole thread or download thread mbox)
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!


Visit WWWdb at

pgsql-hackers by date

Next:From: Colin StricklandDate: 2001-07-04 09:39:50
Subject: RE: [OT] Any major users of postgresql?
Previous:From: Zeugswetter Andreas SBDate: 2001-07-04 08:37:57
Subject: AW: Re: Backup and Recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group