Oracle to PostgreSQL migration with ogr2ogr only imports first geoloc column

by Stepan   Last Updated July 10, 2019 21:22 PM

I transfer Oracle tables to PostGIS using Oracle Wallet and

 ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME>/<PASSWORD>@<SID>:<table>

It transfers all regular columns and the first geoloc column. Tables with multiple geoloc columns are not transferred correctly. I can create pg tables with multiple geoloc columns by joining several tables within Pg client.

Is there a way to copy multiple geoloc columns with ogr2ogr?



Related Questions





Migrating ArcSDE data to Oracle Spatial?

Updated June 10, 2015 12:09 PM

PostGis vs Oracle Spatial 11g performance

Updated July 31, 2017 15:22 PM