Re: PG case sensitivity

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.