Thread: Database joins

On Mon, 9 Sep 2002, Jay wrote:

> Hi,
> I have created two databases, db1 and db2  in my POSTGRESQL database system.
> And both the databases contains few tables also.
> Could you please help me to write a query which should retrieve data from both the databases
> (Database joins and table joins)

You cannot currently directly via sql only do
cross database joins. You might want to see
if contrib/dblink will let you do what you want
(iirc it's gotten better in 7.3 with the
functions returning result set stuff).