select query that would join two databases

From: "Keith H(dot)K(dot) Lam (U1 Tech(dot))" <keithhk_lam(at)u1technology(dot)com>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: select query that would join two databases
Date: 2003-07-30 11:28:04
Message-ID: E1710B82E845F2439B63043F1699E82877C29F@mailserver.tainam.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-07-30 13:48:54 Re: Very strange 'now' behaviour in nested triggers.
Previous Message Paul Thomas 2003-07-30 11:25:25 Re: How can I to solute this problem?