GPSFileDepot Forums

General Category => Map Making Support => Topic started by: Nitin on February 19, 2014, 11:50:46 PM

Title: how to load shape file in postGIS?
Post by: Nitin on February 19, 2014, 11:50:46 PM
I have insatalled PostGreSQL with postGIS by following instructions on the site.
Now i want to load shape file in it. How can i load it?
Title: Re: how to load shape file in postGIS?
Post by: Seldom on February 20, 2014, 06:18:58 AM
There's a utility, shp2pgsql.  Here's a batch file I used to call it but I haven't done that in a while, so I'm not real sure of the syntax.

path="c:\program files (x86)\postgresql\9.0\bin\";%path%
shp2pgsql "c:\pathtoyourinputfile\yourinputfilename.shp" -u postgres -p postgis youroutputfilenamewithnoextension
pause