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

From Net Virtual Mailing Lists
Subject Re: Join between databases or (???)
Date
Msg-id 20041121023712.31576@mail.net-virtual.com
Whole thread Raw
In response to Re: Join between databases or (???)  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Join between databases or (???)
List pgsql-general
I suspect that schemas are the best way to go, but gosh is it going to be
a bear to re-engineer all this stuff... Unfortunately it was all done in
the "pre-schema" days of Postgres and just evolved from there.....

If I want to take an existing table and add it into a schema is it
basically "alter database [database] rename [table] to schema.[table]"?....

.. I guess that I was just looking for confirmation there was not
something in postgres which would allow this "full featured cross-
database join" before pulling an a few all nighters...

Thanks!

- Greg

>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: Casey Duncan
Date:
Subject: Unit testing plpgsql code
Next
From: Michael Fuhr
Date:
Subject: Re: Join between databases or (???)