Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group