Re: Database Name Case Sensitivity
От | Mitch Vincent |
---|---|
Тема | Re: Database Name Case Sensitivity |
Дата | |
Msg-id | 00e701c0be0b$c2fafc00$0b51000a@epox450 обсуждение исходный текст |
Ответ на | Database Name Case Sensitivity (Shaw Terwilliger <sterwill@sourcegear.com>) |
Список | pgsql-general |
I'm not sure about database names but table and field names can be upper case (or contain upper case characters) you just have to reference the table/field in double quotes.. Example : SELECT * FROM "FoBaR"; Hope that helps. -Mitch Software development : You can have it cheap, fast or working. Choose two. ----- Original Message ----- From: "Brian T. Allen" <brian@gzmarketing.com> To: "Shaw Terwilliger" <sterwill@sourcegear.com>; <pgsql-general@postgresql.org> Sent: Thursday, April 05, 2001 3:53 PM Subject: Re: Database Name Case Sensitivity > 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. > > Brian > +++++++++++++++++++++++++++++ > Flash web sites from $149/year w/ hosting > http://www.eflashcash.com/er/websuccess/ > +++++++++++++++++++++++++++++ > > > > Maybe this isn't technically a bug, but I found it strange. With > PostgreSQL > > 7.0.3 and 7.1beta6, I can create a database "FOO", but can only later > connect to > > it as "foo". I'm not sure if this is a psql thing or a backend thing, or > if > > it's intended to be this way, but it makes some of my scripts more > complicated. > > > > -- > > Shaw Terwilliger <sterwill@sourcegear.com> > > SourceGear Corporation > > 217.356.0105 x 641 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
В списке pgsql-general по дате отправления: