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: Pine.LNX.4.30.0105140707510.7644-100000@chapelperilous.net (view raw or flat)
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
				   http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
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-2014 The PostgreSQL Global Development Group