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).