[postgis-users] how to pass dbf to postgis
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.
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
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