Re: Upper and Lower-cased Database names? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Upper and Lower-cased Database names?
Date
Msg-id D960CB61B694CF459DCFB4B0128514C25686D2@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Upper and Lower-cased Database names?  ("Daniel B. Thurman" <dant@cdkkt.com>)
List pgsql-general
Daniel B. Thurman wrote:
> I am finding out for the first time that by having a database created
> with the name: MyTest, I cannot do a simple query as follows:
>
> postgres=# select * from MyTest.public.cars;
> ERROR:  cross-database references are not implemented:
> "mytest.public.cars"

Try:

select * from "MyTest".public.cars;

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: replacing single quotes
Next
From: Owen Hartnett
Date:
Subject: Re: Generating subtotal reports direct from SQL