dkoug Blog

Import shapefile to postgres database

Postgresql -- Posted on Aug. 7, 2017

Import shapefile to postgres database

1
shp2pgsql -d -s srid -W 'UTF-8' path/to/shapefile  database_table  | psql -h 127.0.0.1 -d  database -U  database_user