Postgres Pro
Downloads
Home   >   mailing lists

Thread: Database links in Postgresql.

Database links in Postgresql.

From
"Ricardo D' Aguiar"
Date:
Hi all,
 
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.
 
******************************************************************
Ricardo D'Aguiar

Re: Database links in Postgresql.

From
Stephan Szabo
Date:
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.