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?

  • Do you have all geoloc columns registered in ALL_SDO_GEOM_METADATA? – user30184 Jul 16 at 23:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.