Re: Database links in Postgresql.

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Ricardo D' Aguiar" <ricardo(at)memosis(dot)pt>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database links in Postgresql.
Date: 2001-12-06 23:09:20
Message-ID: 20011206150835.I28880-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)INSTANCE
>
> Thanks in advanced.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-12-06 23:14:53 Re: Trigger problem
Previous Message Stephan Szabo 2001-12-06 23:08:19 Re: Casting Varchar to Numeric