Re: Join between databases or (???)

On Sat, Nov 20, 2004 at 06:09:49PM -0700, Net Virtual Mailing Lists wrote:

> I have situation where multiple databases need to use data from a common
> source and it would consume way too much disk space to reproduce this
> data into the many databases which require it.  Is there some way to do a
> join between databases or some other way of making the data in one
> database available in another in a space-efficient manner?   Of course it
> is necessary that if this is possible any queries need to take advantage
> of indexes/etc.

You could use dblink but it might not provide all the functionality
you're looking for.  Could the multiple databases possibly be converted
into multiple schemas in the same database?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/