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.
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2000-09-24 23:02:25|
|Subject: Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef? |
|Previous:||From: Fredrick Bartlett||Date: 2000-09-24 15:18:53|
|Subject: Re: Select between two databases|