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?
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