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(at)libertyrms(dot)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(at)postgresql(dot)org)
>
>