| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Indraneel Majumdar <indraneel(at)www(dot)cdfd(dot)org(dot)in> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Select between two databases |
| Date: | 2000-09-24 19:46:39 |
| Message-ID: | Pine.BSF.4.10.10009241245050.76483-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sun, 24 Sep 2000, Indraneel Majumdar wrote:
> Does any one know how I may select between two databases running on same
> machine or on different machines eg.
>
> select colA1 from tableA1 where colA2 in (select colB1 from tableB1);
>
> here tableA1 and tableB1 are in different databases. The two databases
> might be under the same postmaster or on different machines under
> different postmasters. How do I query both simultaneously? Is it possible?
Currently postgres databases may not be spanned in queries.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-09-24 23:02:25 | Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef? |
| Previous Message | Fredrick Bartlett | 2000-09-24 15:18:53 | Re: Select between two databases |