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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jairo Sánchez Sent: Tuesday, July 17, 2007 3:44 PM To: [email protected] 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 [email protected] 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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
