pgInsert: No column name matches found in database table.

[mrahiz]

pgInsert: No column name matches found in database table.

[dnbucklin]

You could use the argument partial.match = TRUE to insert only on the columns that have matching names between the existing PostGIS table and the data frame. Note that matching is case-sensitive. In your example, only the column id would transfer.

Also, if your existing PostGIS table has a geometry column, you can just insert the shape Spatial*DataFrame directly, e.g.:

shape <- readOGR(dsn=location,layer="input_shapefile")
pgInsert(con,name=c("master","bounding_box"),data.obj=shape, partial.match = TRUE)

[basille]

Closing it, as there is no activity, and it seems the issue was addressed.