From: Mark Dalphin <mdalphin@amgen.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Data Migration
Date: Thu, 02 Dec 1999 10:03:14 -0800
Message-ID: <3846B461.4A346A92@amgen.com> (raw)
I would find this kind of extension extremely useful! Databases proliferate
here at an unbelievable rate; and then, 3 months later, someone needs to "join
across the DBs". To do this across DBMS, as suggested below, sounds difficult,
but then, I'm not writing the code...
Mark
> > 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 [AS ] [HOST host] [PORT port] [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.
>
--
Mark Dalphin email: mdalphin@amgen.com
Mail Stop: 29-2-A phone: +1-805-447-4951 (work)
One Amgen Center Drive +1-805-375-0680 (home)
Thousand Oaks, CA 91320 fax: +1-805-499-9955 (work)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mdalphin@amgen.com
Subject: Re: [INTERFACES] Data Migration
In-Reply-To: <3846B461.4A346A92@amgen.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox