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

Re: Linking postgres databases

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: Ken Laws <klaws(at)pyramis(dot)co(dot)uk>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Linking postgres databases
Date: 2001-05-14 11:08:52
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
On Mon, 14 May 2001, Ken Laws wrote:

> Is there any way that a query in postgres database, db1, can access data
> from a table in a second postgres database, db2. Alternatively, can a view
> be created in db1 that is sourced from a table in db2.

No.  Support for multiple schemas is planned in a future release, AFAIK.

-- Brett
Classical music is the kind we keep thinking will turn into a tune.
		-- Kin Hubbard, "Abe Martin's Sayings"

In response to

pgsql-novice by date

Next:From: Matus fantomas UhlarDate: 2001-05-14 15:09:42
Subject: convert timestamp to number ?
Previous:From: Ken LawsDate: 2001-05-14 10:20:53
Subject: Linking postgres databases

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