Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: select query that would join two databases
- From: Rod Taylor <rbt(at)rbt(dot)ca>
- To: "Keith H.K. Lam (U1 Tech.)" <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: 31 Jul 2003 20:39:32 -0400
- Message-id: <1059698371.33557.11.camel@jester> <text/plain>
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 >
Attachment:
signature.asc
Description: This is a digitally signed message part
- References:
- select query that would join two databases
- From: Keith H.K. Lam (U1 Tech.)
- select query that would join two databases
- Prev by Date: Re: Does a the block of code within a stored procedure constitute
- Next by Date: Using contrib/fulltext on multiple tables
- Previous by thread: select query that would join two databases
- Next by thread: ALTER TABLE ... DROP CONSTRAINT
- Indexes: