Loading shapefile to a specific table in postgis using ogr2ogr

Question

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?

score 21 · Answer 1 · answered Aug 27 '15 at 03:25

21

To be explicit about nickves' answer:

ogr2ogr -append -f "PostgreSQL" PG:"dbname=db" shapefile.shp -nln mytable

answered Aug 27 '15 at 03:25

Steve Bennett

5,682
2
44
69

1

(-nln is also working for appending to existing tables in geopackages) – BERA Apr 13 '21 at 09:13

score 12 · Answer 2 · answered May 15 '13 at 16:57

12

http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet

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

answered May 15 '13 at 16:57

nickves

11,519
3
42
75

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

Loading shapefile to a specific table in postgis using ogr2ogr

2 Answers2