Re: accessing two databases at the same time

It would be nice if this functionality was in the PG itself....that is
another abstraction layer
with a config file that says

db-1.schema-1.table-1 = { host-i, db-j, schema-1, table-1 }

This would be a real cluster, ie where (which host) a db runs on is
immaterial...

Tariq Muhammad wrote:

>On Wed, 5 Mar 2003, Peter Choe wrote:
>
>
>
>>if i have database 'A' with a table called 'a' and another database 'B'
>>with a table called 'b', is there a way to do a select using both databases
>>and their tables?
>>
>>select * from A.a, B.b;
>>
>>
>>
>
>You may wanna have a look at dblink under contrib.
>
>     _/_/     _/_/    _/_/  Tariq Muhammad
>    _/  _/  _/   _/ _/  _/  tariq@libertyrms.info
>   _/   _/ _/_/_/  _/_/_/   v:416-646-3304 x 111
>  _/   _/ _/   _/ _/  _/    c:416-455-0272
> _/_/_/  _/_/_/  _/  _/     p:416-381-1457
>_________________________________________________
>     Liberty Registry Management Services Co.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>