select query that would join two databases - Mailing list pgsql-sql

From Keith H.K. Lam (U1 Tech.)
Subject select query that would join two databases
Date
Msg-id E1710B82E845F2439B63043F1699E82877C29F@mailserver.tainam.com
Whole thread Raw
Responses Re: select query that would join two databases  (Rod Taylor <rbt@rbt.ca>)
List pgsql-sql
dear all,

How to create a query that would join two databases? In MSSQL, i use

select * from dbA.dbo.tableA a dbB.dbo.tableB b where a.id=b.id

Is there anyway to write the above query in postgressql ?

Please email me back.
Thanks,
Keith


pgsql-sql by date:

Previous
From: Richard Poole
Date:
Subject: Re: One to many query question
Next
From: Andrew Gould
Date:
Subject: Re: [GENERAL] ALTER TABLE ... DROP CONSTRAINT