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