Re: [INTERFACES] Data Migration

On Wed, 1 Dec 1999, D'Arcy J.M. Cain wrote:

> Date: Wed, 1 Dec 1999 16:23:29 -0500 (EST)
> From: "D'Arcy J.M. Cain" <darcy(at)druid(dot)net>
> To: "Roderick A. Anderson" <raanders(at)altoplanos(dot)net>
> Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, rob(at)y2k(dot)state(dot)il(dot)us,
> pgsql-interfaces(at)postgreSQL(dot)org
> Subject: Re: [INTERFACES] Data Migration
>
> 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

Yes, currently we do this at application level, but as pointed out
in previous posts, in web application with using persistence connection
between httpd and db backend it's very important to have support
at db level !

> 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.

That would be really cool, especially in web applications.
Implementation of this feature would be a great win if postgres could
works with several databases **through one connection**.

I think for security reason OPEN DATABASE should contain user info.

Regards,

Oleg
>
> --
> D'Arcy J.M. Cain <darcy(at){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.
>
> ************
>

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83