[postgis-users] how to pass dbf to postgis

Obe, Regina robe.dnd at cityofboston.gov
Tue Jul 17 13:18:18 PDT 2007

You can use OGR2OGR to import a dbf file like this

ogr2ogr -f "PostgreSQL" PG:"host=myserver user=myuser dbname=mydb password=mypassword" D:\GISData\somefile.dbf -nln newtablename

where D:\GISData\somefile.dbf replace with your dbf file
myserver, myuser, mydb, mypassword you can replace with your respective values
newtablename replace with the table you want to create.

More details can be found here  about using OGR2OGR in general

Someone correct me if I am wrong, but I don't think you can import files with shp2pgsql although given that dbf is actually a subset of an esri shape file, it would seem to me a minor change to give it that functionality.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Jairo Sánchez
Sent: Tuesday, July 17, 2007 3:44 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] how to pass dbf to postgis


I have a SIG with his data in dbf and I would like to pass it to
postgis, so I can improve more function to it.
And I'm asking if some has a manual or an HowTo that can help me in
this convertions.


postgis-users mailing list
postgis-users at postgis.refractions.net

The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

More information about the postgis-users mailing list