Skip to main content
  • EN

Hi, Im trying to convert my from Esri shapefile to PostgreSQL database, but the result is not good because the geometry is gone. Im using FME for the first time and dont know where is the problem. Please help!

Are you using the PostgreSQL writer or the PostGIS writer?

If you want to write any geometries, you need to use the PostGIS writer.

I used PostgreSQL writer. I also tried PostGIS writer but didn`t got any result. Should I install some extension to PostgreSQL?

Best regards and thank you

I used PostgreSQL writer. I also tried PostGIS writer but didn`t got any result. Should I install some extension to PostgreSQL?

Best regards and thank you

Yes, you'll need to add the PostGIS extenstion to your PostgreSQL database, see http://postgis.net/ for more information.

 

 

The Postgresql writer will not write any geometries. You need to first install the PostGIS extensions into your Postgresql instance.

You then have to execute the following command in each of your spatially enabled databases:

CREATE EXTENSION postgis;

More information here: https://postgis.net/install/

You can then use the PostGIS writer in FME to write the geometries.

Reply


Community Stats

30,108
Posts
114,290
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.