how to load shape file in postGIS?

[Nitin]

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?

[Seldom]

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.

Code Select Expand

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