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

accessing data from other databases?

From: "Celia McInnis" <celia(at)drmath(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: accessing data from other databases?
Date: 2005-06-11 00:57:37
Message-ID: 20050611004838.M92742@drmath.ca (view raw or flat)
Thread:
Lists: pgsql-novice
I have two separate (postgres) databases each of which contain a set of 
tables with the same names. Now it turns out that one of the tables between 
these two databases can be shared. What's my best way of proceeding? I was 
hoping that I could just access this table from either database, but when I 
try to do so I get the error:

ERROR:   cross-database references are not implemented...

I'd rather not combine the databases, since they are huge, and apart from 
this one table which is relevant to both, they are quite independent. I'm 
also not keen on maintaining two copies of the one table which is relevant to 
both, since it will change with time. Are there any other options?

Thanks for any suggestions,
Celia McInnis

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2005-06-11 01:01:55
Subject: Re: accessing data from other databases?
Previous:From: Havasvölgyi OttóDate: 2005-06-10 21:12:56
Subject: need suggestion for server sizing

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