Received: from localhost (scrappy@localhost) by hub.org (8.8.8/8.7.5) with SMTP id IAA08146; Wed, 27 May 1998 08:03:06 -0400 (EDT) Date: Wed, 27 May 1998 08:03:06 -0400 (EDT) From: The Hermit Hacker To: pgsql-sql@postgresql.org cc: Dirk Lutzebaeck Subject: select across two databases Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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