Re: accessing two databases at the same time

On Wednesday 05 March 2003 21:17, 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;

Not directly, see:

http://www.postgresql.org/docs/faqs/FAQ.html#4.24

The schema functionality added in version 7.3. may well meet
your needs though, e.g. you can define schema "A" and
schema "B" and perform the same sort of query as above.

Ian Barwick
barwick@gmx.net