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

[Norman Vine]

On Jan 29, 2012, at 11:39 PM, pcreso at pcreso.com wrote:

> > When did this become available?
> > I'm using pgsql2shp from Postgis version 1.5.3 for Linux, which is pretty current, 
> > and that is not a listed command line option.
> 
> Not really sure when but see 
> 
>   http://trac.osgeo.org/postgis/browser/trunk/loader/shp2pgsql-cli.c#L22
> 
> --- On Mon, 1/30/12, Richard Greenwood <richard.greenwood at gmail.com> wrote:
> 
> 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
> 
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120130/783f1548/attachment.html>