Обсуждение: Database links in Postgresql.

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.