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