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

[John Morgan]

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

[Richard Greenwood]

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....@gmail.com
www.greenwoodmap.com
_______________________________________________
postgis-users mailing list
postgi...@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[pcr...@pcreso.com]

shp2pgsql is a Postgis utility, not a GDAL one, though GDAL can also do this. Without knowing the platform you are using, recommending a solution is not straightforward. An effective commercial tool, with a free trial, is: http://www.spectralcore.com/fullconvert/ The Postgres Wiki lists a few options: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#DBF_Format Also see the shapefile & DBF loader notes at: http://postgis.refractions.net/download/windows/ Brent Wood --- On Mon, 1/30/12, John Morgan <jdmo...@unca.edu> wrote:

-----Inline Attachment Follows-----

[pcr...@pcreso.com]

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. Cheers,    Brent Wood --- On Mon, 1/30/12, Richard Greenwood <richard....@gmail.com> wrote:

[Richard Greenwood]

It's been around for years. Since 1.4 I'd guess. When you type shp2pgsql you should see this option:
   -n  Only import DBF file.
The OP was how to load a dbf into postgres, you're exporting with pgsql2shp, which will export only the dbf if there is not geometry column in the table being exported.

Rich

[John Morgan]

Thanks for the feedback guys.  The  -n option on  shp2pgsql  worked well.

Derek

[Norman Vine]

On Jan 29, 2012, at 11:39 PM, pcr...@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....@gmail.com> wrote:

On Sun, Jan 29, 2012 at 7:17 PM, John Morgan <jdmo...@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