table name case sensitivity

Started by Daniel J. Kressinabout 25 years ago3 messagesgeneral
Jump to latest
#1Daniel J. Kressin
dkressin@globalcrossing.com

I know that you can make table names case-sensitive by putting them in
quotes. Is there a way (compile-time option, anything?) to make them
case-sensitive by default (i.e. without quotes)?
--
Dan
____ Kressin ____ .-----------------------------------.
/___ \____________/ __ \ | Unix SysAdmin |
\ \ / / \ | | Global Crossing |
___/ __\/\/rench_ \__/ | | dkressin@globalcrossing.com |
\____/ \____/ | http://www.vib.org/wrench/ |
`-----------------------------------'

#2Daniel J. Kressin
dkressin@globalcrossing.com
In reply to: Daniel J. Kressin (#1)
Re: table name case sensitivity

Peter Eisentraut wrote:

Daniel J. Kressin writes:

I know that you can make table names case-sensitive by putting them
in quotes. Is there a way (compile-time option, anything?) to make
them case-sensitive by default (i.e. without quotes)?

No. You need to write to the SQL standards committee if you want to
change this.

Fair enough, thanks. This was actually asked on behalf of a friend, so
no skin off my back. :)
--
Dan
____ Kressin ____ .-----------------------------------.
/___ \____________/ __ \ | Unix SysAdmin |
\ \ / / \ | | Global Crossing |
___/ __\/\/rench_ \__/ | | dkressin@globalcrossing.com |
\____/ \____/ | http://www.vib.org/wrench/ |
`-----------------------------------'

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Daniel J. Kressin (#1)
Re: table name case sensitivity

Daniel J. Kressin writes:

I know that you can make table names case-sensitive by putting them in
quotes. Is there a way (compile-time option, anything?) to make them
case-sensitive by default (i.e. without quotes)?

No. You need to write to the SQL standards committee if you want to
change this.

--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/