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/
>