[postgis-users] tool to load dbf into postgresql table

[Richard Greenwood]

On Sun, Jan 29, 2012 at 7:17 PM, John Morgan <jdmorgan at unca.edu> wrote:
> Hello,
> This may be more of a postgresql question, but it is related to my postgis
> setup.  I was hoping that someone might know of an easy way to load a dbf
> into postgresql table.  I have used the gdal tool shp2pgsql to load a
> shapefile in this way and it worked great.  Is there a similar tool for
> loading just a dbf?
>
> Thanks,
> Derek

Derek,

Use the -n switch with shp2pgsql will do what you want:
   shp2pgsql -n
Also ogr2ogr will do the trick. ogr2ogr can also handle conversions
between numerous other spatial and non-spatial data formats. ODBC is
especially handy.

Rich

--
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com