accessing two databases at the same time

From: Peter Choe <choepete(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: accessing two databases at the same time
Date: 2003-03-05 20:17:18
Message-ID: 5.0.0.25.0.20030305151510.03ce2818@pop.mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

Peter Choe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2003-03-05 20:54:43 Re: accessing two databases at the same time
Previous Message Jason Hihn 2003-03-05 19:49:30 Re: Why PostgreSQL?