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 :)