Re: [GENERAL] Join between tables of two or more databases

From: Scott Marlowe <scott.marlowe(at)gmail.com>
Date: Wed Oct 31 2007 - 11:58:32 EDT

On 10/31/07, Reg Me Please <regmeplease@gmail.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.

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq Received on Wed Oct 31 14:22:29 2007