Re: Select between two databases - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Select between two databases
Date
Msg-id Pine.BSF.4.10.10009241245050.76483-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Select between two databases  (Indraneel Majumdar <indraneel@www.cdfd.org.in>)
List 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.



pgsql-sql by date:

Previous
From: Indraneel Majumdar
Date:
Subject: Re: Select between two databases
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?