Hi,
I'd love it if I could access tables from other databases.
Is there a way to do this?
Here's some sample pseudo-SQL in case I wasn't clear about that:
select * from database1^table3, database2^table4;
Which would do something similar to:
psql -d database1 -c 'select * from table3;'
psql -d database2 -c 'select * from table4;'
All I see when I've read docs, or checked other sources is that databases
are separate, and can't access other info.
I suppose that answers my question -- but it just doesn't seem right.
It'd seem like there oughtta be a way, somehow, to access (at least read!)
data from multiple tables in multiple databases -- at least on the same
site.
There are only two other ways I can think of to do this...
1) Consolidate all tables into a single database. I'd have a lot of
stuff in that database then. Uck.
2) Write scripts that access both databases, and essentially duplicate
some of the database functions in the script.
So far, I do small parts of method 2, and in some cases, simply copy info
from one database to another, duplicating it.
Any other ideas are welcome.
--
RJohnson.com -+- Ron Johnson <rjohnson@rjohnson.com>
http://www2.rjohnson.com/me/1yyiUmKVrL9Sn/