Re: SELECT from a table in another database - Mailing list pgsql-general

From Nils Zonneveld
Subject Re: SELECT from a table in another database
Date
Msg-id 3B015964.AF072405@mbit.nl
Whole thread Raw
In response to SELECT from a table in another database  ("Trygve Falch" <trf@ssb.no>)
List pgsql-general

Trygve Falch wrote:
>
> Hi!
>
> I'm having a problem with a SQL-sentence like this:
>
>         SELECT * from DATABASE.Table;
>
> I get an error saying: 'parse error at or near "."'
>
> I've done this in MySQL and Oracle without any problem, and found it
> strange that I couldn't do it in Postgres.
>
> Am I missing something, or do
> I have to use another syntax to be able to select from tables in another
> databases?

AFAIK cross database joins are not possible in PostgreSQL.

Regards,

Nils Zonneveld

pgsql-general by date:

Previous
From: Chris Hayner
Date:
Subject: help with programming
Next
From: manuel@des01.sanyres.es
Date:
Subject: Form a field from two fields in a select