<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>G'day,</div><div><br></div><div>As a start (and as noted in your previous post), the shp2pgsql program writes a SQL file which you then need to import into postgres - so it is a two stage process - but it is well covered in the manual, so it sounds like something is going wrong.</div><div><br></div><div>Maybe you could include a copy of what you have done, and what output happened when you tried it. Also, are you on windows or *nix? What versions of the software are you using? And what projection do you want the data to be in?<div><br></div><div>cheers</div><div><br></div><div>Ben</div><div><br></div></div><div><div><div>On 11/09/2009, at 4:25 , Cort D wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Please can somebody tell me how to import my ESRI shapefiles and attribute<br>tables into PostGIS.<br>I have been trying to use the shp2pgsql function but its either i am not<br>using it correctly or its just not working for me.<br><br>Please can someone out there help me. I am very new to PostGIS application.<br></div></blockquote></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><br class="Apple-interchange-newline">-- </div><div><br>Ben Madin<br>REMOTE INFORMATION<br><br>t : +61 8 9192 5455<br>f : +61 8 9192 5535<br>m : 0448 887 220<br>Broome WA 6725<br><br><a href="mailto:ben@remoteinformation.com.au">ben@remoteinformation.com.au</a><br><br><br><br><span class="Apple-tab-span" style="white-space: pre; "> </span><span class="Apple-tab-span" style="white-space: pre; "> </span><span class="Apple-tab-span" style="white-space: pre; "> </span><span class="Apple-tab-span" style="white-space: pre; "> </span><span class="Apple-tab-span" style="white-space: pre; "> </span><span class="Apple-tab-span" style="white-space: pre; "> </span><span class="Apple-tab-span" style="white-space: pre; "> </span>Out here, it pays to know...<br><br></div></span>
</div>
<br></div></body></html>