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: (view raw, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group