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: | 2007-10-31 15:58:32 |
Message-ID: | dcc563d10710310858m28b3435ard1b41ca210be599d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Reece Hart | 2007-10-31 16:04:48 | Re: getting list of tables from command line |
Previous Message | Albe Laurenz | 2007-10-31 15:55:34 | Re: Securing stored procedures and triggers |