Mixedbredie's Ghosts
  • Home
  • Contact
Subscribe
Tagged

ogr2ogr

A collection of 2 posts

ogr2ogr: Oracle to PostGIS
postgis

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

  • Ross McDonald
Ross McDonald Nov 3, 2015 • 2 min read
ogr2ogr: PostGIS to PostGIS
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

  • Ross McDonald
Ross McDonald Nov 3, 2015 • 1 min read
Mixedbredie's Ghosts © 2023
Powered by Ghost