Re: SELECT from a table in another database

From: Nils Zonneveld <nils(at)mbit(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT from a table in another database
Date: 2001-05-15 16:29:38
Message-ID: 3B015964.AF072405@mbit.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nils Zonneveld 2001-05-15 17:11:37 Re: Performance aggregates
Previous Message Gyozo Papp 2001-05-15 16:29:26 Re: index ops for _int4 and trees?

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-05-15 16:47:52 Re: Configurable path to look up dynamic libraries
Previous Message Gyozo Papp 2001-05-15 16:29:26 Re: index ops for _int4 and trees?