Skip site navigation (1) Skip section navigation (2)

Re: Select between two databases

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 (view raw or flat)
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.


In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2000-09-24 23:02:25
Subject: Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?
Previous:From: Fredrick BartlettDate: 2000-09-24 15:18:53
Subject: Re: Select between two databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group