[postgis-users] how to pass dbf to postgis

[Obe, Regina]

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
http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet

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.


Thanks,
Regina 

-----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

Hi,

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.

thanks.

JSLL
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
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.