| 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 |