Re: Database links in Postgresql. - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Database links in Postgresql.
Date
Msg-id 20011206150835.I28880-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Database links in Postgresql.  ("Ricardo D' Aguiar" <ricardo@memosis.pt>)
List pgsql-general
On Mon, 3 Dec 2001, Ricardo D' Aguiar wrote:

> I need to know if there is a way to implement database links to connect two
> database.
>
> The intention is to make a SELECT in DB(A) but the real data be in DB(B).
> These schema is possible to implement in other DB manufactures like Oracle
> where I can make something like this:
>
> SELECT * FROM TABLE@INSTANCE
>
> Thanks in advanced.

Unfortunately you cannot currently make cross-db queries directly through
SQL in PostgreSQL.



pgsql-general by date:

Previous
From: mordicus
Date:
Subject: Trigger problem
Next
From: Stephan Szabo
Date:
Subject: Re: Trigger problem