Query two database at once - Mailing list pgsql-sql

From Stéphane RIFF
Subject Query two database at once
Date
Msg-id 427648E5.6080306@cerene.fr
Whole thread Raw
Responses Re: [despammed] Query two database at once  (Andreas Kretschmer <akretschmer@despammed.com>)
List pgsql-sql
Hi,

I want to ewecute a query on two database like this :

SELECT * FROM table01 T1, table02 T2 WHERE T1.gid=T2.gid AND 
T2.my_field='".$value."'

The problem is that table01 is in a different database than table02 and 
i don't know how to telle postgresql
to look in two db.
Is there a solution other than execute two query ?
Thanks


pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: how many tuples on a cursor?
Next
From: "Sam Adams"
Date:
Subject: Java and Currval