Re: Re: Database Name Case Sensitivity - Mailing list pgsql-general

From Brian T. Allen
Subject Re: Re: Database Name Case Sensitivity
Date
Msg-id 00cb01c0be0c$ebe592f0$2718b3cf@picard
Whole thread Raw
In response to Re: Database Name Case Sensitivity  (Joel Burton <jburton@scw.org>)
Responses diff -c pgsql mysql (Was Database Name Case Sensitivity)
List pgsql-general
I am sure it is a Good Thing, thank you for the explanation.  I will just
have to change my thinking to all lowercase and get used to it.

Sort of on the same topic, does anyone know of a PostgreSQL primer for those
making the change from MySQL.  Changing religions :}  is never easy,
something to ease the transition and point out the differences and gotchas
would be very helpful.

Thanks for the help,
Brian
+++++++++++++++++++++++++++++
Flash web sites from $149/year w/ hosting
http://www.eflashcash.com/er/websuccess/
+++++++++++++++++++++++++++++


> On Thu, 5 Apr 2001, Brian T. Allen wrote:
>
> > I just ran into that too, and find it most undesirable.  I don't know
> > whether that is part of the SQL spec or not, but it seems very odd.  The
> > queries seem to be converted to lowercase before they ever reach the SQL
> > engine.
>
> Everything is postgresql is lowercased, unless system identifiers (double
> quotes) are wrapped around it.
>
>   CREATE DATABASE foo
>
> is the same as
>
>   CREATE DATABASE FOO
>
> or
>
>   CREATE DATABASE Foo
>
>
> You must connect to it with
>
>   \c foo
>
>
> However, if you
>
>   CREATE TABLE "FOO"
>
> then it is not lowercased. You must connect as
>
>   \c FOO
>
>
> I think this is a Good Thing. It allows most people to have
> case-insensitive system identifiers (at least they appear
> case-insensitive, since it lowercases everything). This plays well with
> other database systems. If you want case-sensitive identifiers, you just
> wrap them wiuth the double quotes.
>
> (cf to the mess in MySQL, where some things are case-sensitive, and some
> things aren't, and it varies based on whether the server OS is case
> sensitive. Ick.)
>
> --
> Joel Burton   <jburton@scw.org>
> Director of Information Systems, Support Center of Washington
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Database Name Case Sensitivity
Next
From: "ADBAAMD"
Date:
Subject: Re: Database Name Case Sensitivity