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
>