Welcome, Guest. Please login or register.

Login with username, password and session length
Forums Search:  


Author Topic: how to load shape file in postGIS?  (Read 4673 times)

Nitin

  • Newbie
  • *
  • Posts: 1
  • Karma: 0
    • View Profile
how to load shape file in postGIS?
« 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?

Seldom

  • Expert Advisor
  • *****
  • Posts: 1852
  • Karma: 19
    • View Profile
Re: how to load shape file in postGIS?
« Reply #1 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.

Code: [Select]
path="c:\program files (x86)\postgresql\9.0\bin\";%path%
shp2pgsql "c:\pathtoyourinputfile\yourinputfilename.shp" -u postgres -p postgis youroutputfilenamewithnoextension
pause
« Last Edit: February 20, 2014, 06:20:42 AM by Seldom »