Skip to main content
New

Dynamic featureWriter - PostGIS Format : force native geometry type

Related products:FME FormTransformers
  • June 9, 2026
  • 0 replies
  • 4 views

arthur_bazin
Contributor
Forum|alt.badge.img+19

When using a Dynamic featureWriter with the PostGIS format you can handle the FeatureType geometry these ways :

  • From first feature
  • From schema definition
  • Define one specific geometry type

None of them are really satisfying for me :

  • From first feature : if you have multiple datatypes you need to order your features or to coerce them leading to the second one
  • From schema definition : no fme_geometry maps cleanly PostGIS geometry types (no support for multicurves or multisurfaces)
  • Define one specific geometry type : not dynamic

It could be great to use a specific attribute : fme_native_geometry_type to define wich geometry type to use in a dynamic writer.

  • This could be for any format (not just for PostGIS but I need it for PostGIS πŸ˜‰)
  • This could be populated by readersΒ 
  • You could provide some transformers :
    • to set this parameter depending on the feature geometry
    • to set manually this parameter (choose format and then geometry type)
    • to coerce geometries as defined by this parameterΒ