Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle Postgres Conversion - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: Oracle Postgres Conversion
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17D010E7@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: Oracle Postgres Conversion  (Gabriele Lohss <gabriele.lohss@gmail.com>)
List pgsql-admin
Tree view 
Gabriele Lohss wrote:
> thanks for all tipps. Do you know if ora2pg and oracle_fdw support postgis or geographical datatypes
> like oracle locator?

oracle_fdw does not support these.
I have had requests for that but lack the expertise.
Is there a compatible format for both PostGIS and Oracle Locator?
If yes, you could use views and pass the field through as binary data.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: wambacher
Date:
Subject: Re: which slony to start?
Next
From:
Date:
Subject: question regarding setup DSN