<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On Jan 29, 2012, at 11:39 PM, <a href="mailto:pcreso@pcreso.com">pcreso@pcreso.com</a> wrote:</div></div><div><br></div><div><blockquote type="cite"><table cellspacing="0" cellpadding="0" border="0" style="position: static; z-index: auto; "><tbody><tr><td valign="top" style="font: inherit;">> When did this become available?<br>> I'm using pgsql2shp from Postgis version 1.5.3 for Linux, which is pretty current, <br>> and that is not a listed command line option.<br><br>Not really sure when but see <br><br> <a href="http://trac.osgeo.org/postgis/browser/trunk/loader/shp2pgsql-cli.c#L22">http://trac.osgeo.org/postgis/browser/trunk/loader/shp2pgsql-cli.c#L22</a><br><br>--- On <b>Mon, 1/30/12, Richard Greenwood <i><<a href="mailto:richard.greenwood@gmail.com">richard.greenwood@gmail.com</a>></i></b> wrote:<blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: rgb(16, 16, 255); margin-left: 5px; padding-left: 5px; position: static; z-index: auto; "><br><div class="plainMail">On Sun, Jan 29, 2012 at 7:17 PM, John Morgan <<a ymailto="mailto:jdmorgan@unca.edu" href="x-msg://348/mc/compose?to=jdmorgan@unca.edu">jdmorgan@unca.edu</a>> wrote:<br>>
Hello,<br>> This may be more of a postgresql question, but it is related to my postgis<br>> setup. I was hoping that someone might know of an easy way to load a dbf<br>> into postgresql table. I have used the gdal tool shp2pgsql to load a<br>> shapefile in this way and it worked great. Is there a similar tool for</div><div class="plainMail"><br>Use the -n switch with shp2pgsql will do what you want:<br> shp2pgsql -n<br>Also ogr2ogr will do the trick. ogr2ogr can also handle conversions<br>between numerous other spatial and non-spatial data formats. ODBC is<br>especially handy.</div></blockquote></td></tr></tbody></table></blockquote></div></body></html>