[gdal-dev] Specify the geometry column name when appending data - PostGIS

[tom]

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.