Re: Upper and Lower-cased Database names?

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Daniel B(dot) Thurman *EXTERN*" <dant(at)cdkkt(dot)com>, "Pgsql-General \(E-mail\)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upper and Lower-cased Database names?
Date: 2007-10-10 11:20:27
Message-ID: D960CB61B694CF459DCFB4B0128514C25686D2@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Owen Hartnett 2007-10-10 11:22:34 Re: Generating subtotal reports direct from SQL
Previous Message Albe Laurenz 2007-10-10 11:18:51 Re: replacing single quotes