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