As the title explains, I have a shapefile whose attribute table has no geometry column specifying the location of points. Rendered in QGIS, it looks fine, so the geometry data is obviously there. Can't import it into a postgresql database using shp2pgsql without a geometry column (Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist). What am I missing here? How can I add the spatial data to the attribute table?
nevermind (edit): bah, it seems that i've let my mind go and i did not set up the new db with the postgis template: more here - http://stackoverflow.com/questions/7323857/postgresql-shp2pgsql-addgeometrycolumn-gives-no-function-matches-the-given-na
