On Wed, 2003-03-05 at 16:09, 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.
Or put the data into 2 different schemas -- a single query can access
relations in different schemas.
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC