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

Re: accessing data from other databases?

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Celia McInnis" <celia(at)drmath(dot)ca>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: accessing data from other databases?
Date: 2005-06-11 01:01:55
Message-ID: 000001c56e21$37688520$5179f345@WATSON (view raw or flat)
Thread:
Lists: pgsql-novice
See the contrib/dblink directory in the postgres distribution.

Sean
----- Original Message ----- 
From: "Celia McInnis" <celia(at)drmath(dot)ca>
To: <pgsql-novice(at)postgresql(dot)org>
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 
> 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
>
> ---------------------------(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 IIIDate: 2005-06-11 02:36:26
Subject: Re: accessing data from other databases?
Previous:From: Celia McInnisDate: 2005-06-11 00:57:37
Subject: accessing data from other databases?

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