Re: Oracle Postgres Conversion

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Gabriele Lohss *EXTERN*" <gabriele(dot)lohss(at)gmail(dot)com>, goutham goud <gouthamgoud(at)live(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Oracle Postgres Conversion
Date: 2014-06-10 09:24:52
Message-ID: A737B7A37273E048B164557ADEF4A58B17D010E7@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Suzana.Sternberg 2014-06-10 21:08:15 question regarding setup DSN
Previous Message wambacher 2014-06-04 22:22:51 Re: which slony to start?