select across two databases
Marc G. Fournier <scrappy@hub.org>
From: The Hermit Hacker <scrappy@hub.org>
To: pgsql-sql@postgresql.org
Cc: Dirk Lutzebaeck <lutzeb@cs.tu-berlin.de>
Date: 1998-05-27T12:03:06Z
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