Received: from druid.net (root@druid.net [216.126.72.98])
	by hub.org (8.9.3/8.9.3) with ESMTP id QAA07853
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 1 Dec 1999 16:23:52 -0500 (EST) (envelope-from darcy@druid.net)
Received: from localhost (1765 bytes) by druid.net
	via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp
	(sender: <darcy>) (ident <darcy> using unix)
	id <m11tHDl-0000cRC@druid.net> for <pgsql-interfaces@postgreSQL.org>;
	Wed, 1 Dec 1999 16:23:29 -0500 (EST)
	(Smail-3.2.0.104 1998-Nov-20 #4 built 1999-Apr-13)
Message-Id: <m11tHDl-0000cRC@druid.net>
Subject: Re: [INTERFACES] Data Migration
In-Reply-To: <Pine.LNX.4.04.9912011214040.30244-100000@asgard.altoplanos.net>
	from "Roderick A. Anderson" at "Dec 1, 1999 12:29:12 pm"
To: raanders@altoplanos.net (Roderick A. Anderson)
Date: Wed, 1 Dec 1999 16:23:29 -0500 (EST)
From: "D'Arcy" "J.M." Cain <darcy@druid.net>
Cc: tgl@sss.pgh.pa.us, rob@y2k.state.il.us, pgsql-interfaces@postgreSQL.org
X-Mailer: ELM [version 2.4ME+ PL50 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Thus spake Roderick A. Anderson
> On Wed, 1 Dec 1999, Tom Lane wrote:
> > No; in Postgres, different databases are different universes ... and
> > there are no wormholes in SQL ;-).
> 
> Does SQL92 say no wormholes?  Is it a major pain to code this?  I've got
> no complaints as I can see ways to do it from the application level.

I don't know what SQL92 says and. like you, I have easy ways to do this
at the app level but for what it's worth, here's a suggested syntax
for this in case someone want to implement it.

OPEN DATABASE <dbname> [AS <alias>] [HOST host] [PORT port] [TYPE <db type>]

And use it as

OPEN DATABASE db1 HOST 'other.what.com';
SELECT * FROM mytab, db1.othertab yourtab
    WHERE mytab.f1 = yourtab.f1;

or

SELECT mytab.f1, db1.yourtab.f2, ...

The TYPE attribute allows for opening other databases such as Oracle, etc.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.