Re: Join between databases or (???) - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Join between databases or (???)
Date
Msg-id 20041121030339.GA64590@winnie.fuhr.org
Whole thread Raw
In response to Join between databases or (???)  ("Net Virtual Mailing Lists" <mailinglists@net-virtual.com>)
Responses Re: Join between databases or (???)
List pgsql-general
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/

pgsql-general by date:

Previous
From: "Net Virtual Mailing Lists"
Date:
Subject: Join between databases or (???)
Next
From: Casey Duncan
Date:
Subject: Unit testing plpgsql code