SELECT across two databases

Dirk Lutzebaeck <lutzeb@cs.tu-berlin.de>

From: Dirk Lutzebaeck <lutzeb@cs.tu-berlin.de>
To: pgsql-sql@postgresql.org
Date: 1998-05-27T14:35:14Z
Lists: pgsql-sql
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