SELECT across two databases - Mailing list pgsql-sql

From Dirk Lutzebaeck
Subject SELECT across two databases
Date
Msg-id 13676.9322.689673.963792@gate.wadk-berlin.de
Whole thread Raw
List 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

pgsql-sql by date:

Previous
From: Jerome ALET
Date:
Subject: nextval
Next
From: "Anton Stöckl"
Date:
Subject: Re: [SQL] nextval