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/ > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
