| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | "Keith H(dot)K(dot) Lam (U1 Tech(dot))" <keithhk_lam(at)u1technology(dot)com> |
| Cc: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: select query that would join two databases |
| Date: | 2003-08-01 00:39:32 |
| Message-ID: | 1059698371.33557.11.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Johnson | 2003-08-01 00:54:45 | Using contrib/fulltext on multiple tables |
| Previous Message | Rod Taylor | 2003-08-01 00:37:18 | Re: Does a the block of code within a stored procedure constitute |