ogr2ogr

Tagged

A collection of 2 posts

ogr2ogr: Oracle to PostGIS

Traditionally^ exporting from Oracle to PostGIS involved an intermediate step Oracle to Shapefile and then Shapefile to PostGIS. But this means that field names longer than 10 characters in Oracle get truncated in the conversion to Shapefile. And using the QGIS or PgAdminIII shp2pgsql gui has no easy way to

postgis

ogr2ogr: PostGIS to PostGIS

I recently^ had to update a live database with updated tables from a staging database and then continue to update on a daily basis. As it is a regular update and the source and destination tables won’t change I generated a text file with a list of layers to