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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
