I have already created a geometry table in postgis. I want to load several shapefiles into that table using ogr2ogr. But I didn't find the parameter which could specify that table.

ogr2ogr -append -f "PostgreSQL" PG:"dbname=db and so on" shapefile.shp 

That's it. How can I add some parameter to specify the table?


To be explicit about nickves' answer:

ogr2ogr -append -f "PostgreSQL" PG:"dbname=db" shapefile.shp -nln mytable 
  • 1
    (-nln is also working for appending to existing tables in geopackages) – BERA Apr 13 at 9:13


use the flag -nln to specify the name of your target table

  • 2
    Another Question regarding that: Can I add some parameter using this command. Such as the user defined ID ? – Yu Guo May 15 '13 at 17:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.