Re: Database Name Case Sensitivity

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
>