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/