Обсуждение: select query that would join two databases

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

Take a look at the dblink() contrib module.

PostgreSQL does not currently support inter-database joins BUT it does
offer Schemas which is often enough.  Take each of your source databases
and toss them into two different schemas of the same database.

On Wed, 2003-07-30 at 07:28, Keith H.K. Lam (U1 Tech.) wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>