Or maybe the question I should really be asking myself is simply: 'How do you import a dbf into PostgreSQL on a Mac?' (Which seems a bit obvious now that I'm typing it, but I'd like to post this question anyway for anyone else who might run into this problem). There is only a Unix executable shp2pgsql in the bin folder.Īre my only options for importing the dbfs to use the command line and/or to do this through QGIS, per another answer on the linked SE question/answer above? I am not finding any other solutions. The Windows installation of PostgreSQL/PostGIS has a shapefile loader gui shp2pgsql-gui.exe, but unfortunately this does not appear to be included in the Mac install.

It is a lightweight, free open source GUI that helps you manage tables, logs and users, edit data, views, procedures and scheduled events, and is continuously enhanced by the active group of contributors. And I know it should work because it is working for everyone using Windows for the PostGIS tutorial I'm following on Udemy (meaning, there is nothing wrong with the dbf itself). HeidiSQL is a new addition to our best PostgreSQL GUI tools list in 2021. The pgShapeLoader GUI worked fine for me when importing shapefiles, but it is producing the above error for the dbfs. I am receiving the following error when trying to import a dbf file into PostgreSQL (v 12, pgAdmin 4) using the Boundless/OpenGeo Suite for Mac pgShapeLoader GUI (which was recommended for Mac users in a Stack Exchange answer here, since there is no shapefile importer GUI included in the most recent Mac installation: Shapefile loader in pgAdmin 4): Failed SQL begins: 'CREATE INDEX ON 'public'.'soildef' USING GIST ('geom') įailed in pgui_exec(): ERROR: column 'geom' does not exist

Best postgres mac gui