+7Hi, 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:
Best answer by nielsgerrits
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.
+61What 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.
+7I am stupid, I removed GEOM and used PostGIS writer instead to the database and that worked, usin geom as geometery column
