select across two databases

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Cc: Dirk Lutzebaeck <lutzeb(at)cs(dot)tu-berlin(dot)de>
Subject: select across two databases
Date: 1998-05-27 12:03:06
Message-ID: Pine.BSF.3.96.980527080241.301E-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-sql by date

  From Date Subject
Next Message Basma, Stein-Aksel 1998-05-27 12:13:26 subscribe
Previous Message engelbert gruber 1998-05-27 08:37:55 Re: [SQL] escaping the '