+3Hi all
I want to define the Geometry Type in PostGIS-Writer. I recently changed from an old version of FME to version 2025.2 In the user dialog of the writer there ist still a field for the definition (feature type/user attributes/spatial definition/geometry type, but the field is de-activated (grayed out).
Is there a way to “manually” define the geometry type for postgis tables?
Thank you for any help.
Best answer by andreaatsafe
For PostGIS, you’ll need to uncheck the “Create Generic Spatial Columns” in the writers parameters when you first add the writer:
Then you’ll be able to configure the Geometry(previously Spatial) Definition table to set the geometry type as
+71By default the writer will be set to Automtaic Spatial (and Schema) definition. This uses the incoming geometry on the feature to write the specific geometry type. In the writer parameters, User Attributes, change the Attribute Definition to Manual and that will allow you to manually define the Geometry Type
+15For PostGIS, you’ll need to uncheck the “Create Generic Spatial Columns” in the writers parameters when you first add the writer:
Then you’ll be able to configure the Geometry(previously Spatial) Definition table to set the geometry type as
