SELECT across two databases

From: Dirk Lutzebaeck <lutzeb(at)cs(dot)tu-berlin(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT across two databases
Date: 1998-05-27 14:35:14
Message-ID: 13676.9322.689673.963792@gate.wadk-berlin.de
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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Anton Stckl 1998-05-27 15:33:46 Re: [SQL] nextval
Previous Message Jerome ALET 1998-05-27 14:22:31 nextval