Re: PG case sensitivity - Mailing list pgsql-general

From Harald Fuchs
Subject Re: PG case sensitivity
Date
Msg-id puu0u1hrg4.fsf@srv.protecting.net
Whole thread Raw
In response to PG case sensitivity  (Christian Sell <christian.sell@netcologne.de>)
List pgsql-general
In article <200409141353.12147.peter_e@gmx.net>,
Peter Eisentraut <peter_e@gmx.net> writes:

> Christian Sell wrote:
>> 1) can PG be configured to operate case insensitive?

> No.

>> 2) why in the world was case sensitivity introduced at all?

> Because the SQL standard specifies it.

I think it's the other way round.  "CREATE TABLE SHIT" and "create
table shit" are the same according to the SQL standard, and they are
the same for PostgreSQL.  The 'gotcha' is that when you ask PostgreSQL
for the table name you get "shit" and not "SHIT", as opposed to many
other DBMSs.

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Grant
Next
From: Alvaro Herrera
Date:
Subject: Re: Corrupted Data?