Re: Link Oracle tables in Postgre

From: Richard Huxton <dev(at)archonet(dot)com>
To: OpenGis <opengis(at)libero(dot)it>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Link Oracle tables in Postgre
Date: 2003-10-01 15:43:39
Message-ID: 200310011643.39500.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday 01 October 2003 16:24, OpenGis wrote:
> Howdy,
>
> I’d like to do (live) link of Oracle table (on win) in Postgres (on RH9
> box).
> In Oracle are stored attribute of my spatial layer collect in
> postgres-postgis geo-database ono-to-one relationship. I use Mapserver
> (http://mapserver.gis.umn.edu) in order to render web map stored in
> postgres. I need to perform filer after do JOIN between oracle-postgres
> data.

You might want to search the mailing list archives for discussion of an oracle
version of dblink - I seem to remember someone saying they were working on
such a thing.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-10-01 15:58:20 Re: Creating Index
Previous Message CN 2003-10-01 15:25:42 Re: Creating Index