I found a solution to my issue for anyone else looking to append data to an existing Postgre table with multiple geometry columns. The syntax was relatively straightforward and was found after re-reading http://www.gdal.org/drv_pg_advanced.html. My working example is shown below:
ogr2ogr -update -append -f "PostgreSQL" PG:"host=192.168.1.xxx port=5432 user=foo password=bar dbname=database" -nln schema.table(geom_column_name) C:/Temp/stuff.sqlite Nodes The trick was using -nln schema.table(geom_column_name) which explicitly specifies the name of the existing table and geometry column we want to import into. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Specify-the-geometry-column-name-when-appending-data-PostGIS-tp5216416p5219001.html Sent from the GDAL - Dev mailing list archive at Nabble.com. _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
