PostgreSQL does not support this feature at this time. And, I would not
expect it any time soon. You would have to either code such a join by
hand.
There is one other option. Many ODBC compliant tools will support
multi-data source joins. However this solution may perform poorly
because one side of the join may iteratively query one of the data
sources. Your call.
Irk Lutzebaeck wrote:
> hi,
>
> when I have two databases say db1 and db2 can there be a select
> statement which accesses both databases eg.
>
> select * from db1.t1,db2.t2 (which is illegal syntax in postgresql but
> legal in informix)
>
> Is there another way to select several databases/namespaces at once?
>
> Dirk