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