Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Join between tables of two or more databases
- From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
- To: "Reg Me Please" <regmeplease(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Join between tables of two or more databases
- Date: Wed, 31 Oct 2007 10:58:32 -0500
On 10/31/07, Reg Me Please <regmeplease(at)gmail(dot)com> wrote: > Il Wednesday 31 October 2007 11:47:46 T.J. Adami ha scritto: > > The question is: can I do this using remote database servers > > (different hosts)? If does not, can I do it at least on local > > databases on the same server? > > > As far as they are "different databases", you cannot do it at the moment. > It doesn't matter whether they are local or not. > The only option should be to do it at the application level with two > connections. Or put the databases into schemas in the same database. If you need the join two datasets in pgsql, they need to be in the same database.
- References:
- Join between tables of two or more databases
- From: T.J. Adami
- Re: Join between tables of two or more databases
- From: Reg Me Please
- Join between tables of two or more databases
- Prev by Date: Re: Securing stored procedures and triggers
- Next by Date: Re: getting list of tables from command line
- Previous by thread: Re: Join between tables of two or more databases
- Next by thread: Re: Join between tables of two or more databases
- Indexes: