Skip to main content

Hi, I have this workspace and databse connection, worked nicely to write to a table.

This is geometry column for another table in PGAdmin

 

My workspace using the PostGreSQL writer:

 

But for some reason, even if I add column geom manually in pg admin after, it refuses to write. What could I be doing wrong? The column jsut never appears, maybe it is a pgadmin question not FME question how I store the geodata, not as X,Y points but as readable geometry like this:

 

 

Are you using the postgres writer or the postgis writer?

PostGRESQL writer

What happens if you create the table using the PostGIS writer instead?

No expert but I think if you create the table using the PostgreSQL writer it is missing the spatial extension.

I am stupid, I removed GEOM and used PostGIS writer instead to the database and that worked, usin geom as geometery column

Most of what I know is because I tried and failed :)

Community Stats

32,015
Posts
121,597
Replies
39,636
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.