Saturday, September 12, 2015

FIXED: Shape file import error in Postgis AddGeometry column doesn't exist

Last week I have installed PostgreSql/PostGis and PgAdmin. Once I have tired to import shape file from PgAdmin using "PostGIS Shape file and DBF Loader 2.1" as below.


But it throws an error complaining "File import error in PostGis AddGeometry column doesn't exist" as shown in figure below 

Then, I found out that the spatial extension is not enabled in my database. The following image shows the steps to enabled the spatial extension in the database. 

Open new extension and name it postgis.

 



Then import the shape file again... Voila it works

PostGIS

2 comments :

  1. Hi Man, you are the best....the most easy way....works fine and fast.... thanks.

    ReplyDelete

 

© 2011 GIS and Remote Sensing Tools, Tips and more .. ToS | Privacy Policy | Sitemap

About Me