Thread: table name case sensitivity

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/        |
                          `-----------------------------------'

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/        |
                          `-----------------------------------'

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/