Re: Upper and Lower-cased Database names?

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: "Daniel B(dot) Thurman" <dant(at)cdkkt(dot)com>
Cc: "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upper and Lower-cased Database names?
Date: 2007-10-10 08:14:02
Message-ID: 7be3f35d0710100114g18fc6a6g89e36702cfa0156c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Daniel,

please try:

select * from "MyTest".public.cars;

mixed cases need those ", per SQL-Standard. In my experienced mixed cases in
qualifiers which cross OS-barriers cause more trouble then use (...
filenames with WebServers ...)

Harald

> postgres=# select * from MyTest.public.cars;
> ERROR: cross-database references are not implemented: "mytest.public.cars
> "
>

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2007-10-10 08:20:14 Re: Upper and Lower-cased Database names?
Previous Message Christian Rengstl 2007-10-10 08:13:53 Re: Upper and Lower-cased Database names?