Linking postgres databases

From: "Ken Laws" <klaws(at)pyramis(dot)co(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Linking postgres databases
Date: 2001-05-14 10:20:53
Message-ID: 71365A62D47FD311B2660090274ECA90182F4A@DEVTAS01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is there any way that a query in postgres database, db1, can access data
from a table in a second postgres database, db2. Alternatively, can a view
be created in db1 that is sourced from a table in db2.

Reason: Db2 could be a corporated reference database that is used by all
other corporate systems. Rather than having many copies of reference tables,
it would be nice if there was only one version of such tables.

regards

Ken Laws

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Brett W. McCoy 2001-05-14 11:08:52 Re: Linking postgres databases
Previous Message Tom Lane 2001-05-13 15:33:55 Re: Can't list tables