Re: Re: Database Name Case Sensitivity
От | Brian T. Allen |
---|---|
Тема | Re: Re: Database Name Case Sensitivity |
Дата | |
Msg-id | 00cb01c0be0c$ebe592f0$2718b3cf@picard обсуждение исходный текст |
Ответ на | Re: Database Name Case Sensitivity (Joel Burton <jburton@scw.org>) |
Ответы |
diff -c pgsql mysql (Was Database Name Case Sensitivity)
|
Список | 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 по дате отправления: