See the contrib/dblink directory in the postgres distribution.
----- Original Message -----
From: "Celia McInnis" <celia(at)drmath(dot)ca>
Sent: Friday, June 10, 2005 8:57 PM
Subject: [NOVICE] accessing data from other databases?
>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
> 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
> 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
> both, since it will change with time. Are there any other options?
> Thanks for any suggestions,
> Celia McInnis
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
In response to
pgsql-novice by date
|Next:||From: Bruno Wolff III||Date: 2005-06-11 02:36:26|
|Subject: Re: accessing data from other databases?|
|Previous:||From: Celia McInnis||Date: 2005-06-11 00:57:37|
|Subject: accessing data from other databases?|