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