pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedselect query that would join two databases
2+ messages / 2 participants
[nested] [flat]
* select query that would join two databases
@ 2003-07-30 11:28 Keith H.K. Lam (U1 Tech.) <keithhk_lam@u1technology.com>
2003-08-01 00:39 ` Re: select query that would join two databases Rod Taylor <rbt@rbt.ca>
0 siblings, 1 reply; 2+ messages in thread
From: Keith H.K. Lam (U1 Tech.) @ 2003-07-30 11:28 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: select query that would join two databases
2003-07-30 11:28 select query that would join two databases Keith H.K. Lam (U1 Tech.) <keithhk_lam@u1technology.com>
@ 2003-08-01 00:39 ` Rod Taylor <rbt@rbt.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Rod Taylor @ 2003-08-01 00:39 UTC (permalink / raw)
To: Keith H.K. Lam (U1 Tech.) <keithhk_lam@u1technology.com>; +Cc: 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
>
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-01 00:39 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-30 11:28 select query that would join two databases Keith H.K. Lam (U1 Tech.) <keithhk_lam@u1technology.com>
2003-08-01 00:39 ` Rod Taylor <rbt@rbt.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox