Re: Loading Oracle Spatial Data to Postgresql - Mailing list pgsql-general

On Thu, 2020-08-20 at 14:30 +0000, Ko, Christina wrote:
> I am running into issue using DMS to load oracle spatial data (oracle 11.2.0.3) to postgresql.
> 
> Oracle table:
> 
> CREATE TABLE Spatial_Tbl
>  ID        NUMBER(38,9),
>   P_ID      NUMBER(38,9),
>   GEOMETRY  MDSYS.SDO_GEOMETRY

If the geometries are not exotic, oracle_fdw would do the trick.

You won't be able to install it on a hosted database though.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com