[postgis-users] Link Oracle tables in Postgres

[Paul Ramsey]

There was some talk of extending the contrib/dblink extention of PgSQL to 
support linking to Oracle databases. I would check out contrib/dblink and 
see what it does right now. Probably Oracle live link is still a glimmer in 
the eye, not a reality. Remember, if you want something done fast, pay the 
developer (in this case, Joe Conway, I think).
P.

Quoting Tyler Mitchell <TMitchell at lignum.com>:
> 
> Since Postgres doesn't even support linking across postgres databases,
> you'll probably have to resort to do it in a separate program - i.e. using
> python to query both and pull the results together for you.   I don't
> believe there is a straightforward, non-programmatic, way to do this 
unless
> you use some tool as described or use something (like M$ Access) to pull
> together various ODBC data sources.
> 
> postgis-users-bounces at postgis.refractions.net wrote on 09/30/2003 09:01:30
> AM:
> 
> > Howdy,
> >
> > I’d like to do (live) link of Oracle table (on win) in Postgres (on
> > linux box).
> >
> > In Oracle are stored attribute of my spatial layer collect in
> > postgres-postgis database.
> >
> > Any suggest?
> >
> >
> > Thank
> >
> > Paolo
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users