I need to write features, coming from a WFS, into PostGIS (I'm using FME 2017.1 Build 17532).
Requirements:
1. As the WFS delivers lots of feature types I want to do it dynamically (Dynamic Schema Definition)
2. I need to change table names to lowercase (not only attribute names)
3. I want to dynamically delete all attributes containing "gml_" or "xsi_nil" in their names.
No. 2:
I copy the format attribute fme_feature_type to a new attribute that I call lowercase_feature_type and change its case. The original fme_feature_type goes into "Schema Definition Name" (so that the writer finds the original schema from the reader), lowercase_feature_type goes into "Table Name".
Problem: Apparently there's still a bug in the PostGIS writer so that in the dynamic case the "Table Qualifier" parameter is not respected at all. I solved this by concatenating the desired schema name to lowercase_feature_type separated by a point before assigning it to "Table Name". So far so good.
No 3:
How can I delete attributes from the schema before writing the PostGIS schema?
The BulkAttributeRemover (with my regular expression "(gml_)|(xsi_nil)") does the job but only in the data flow, it doesn't change the schema written by the PostGIS writer (as the writer reads the schema directly from the reader).
How can I somehow generate dynamically reduced Schemas (build schema Features?) so that I can select "Schema From Schema Feature" in the "Schema Source" parameter in the writer's feature type properties?
No 1:
Apparently, there's another bug in the PostGIS writer (https://knowledge.safe.com/questions/32101/featurewriter-postgis-writes-generic-geometry-colu.html):
When using it dynamically, it always defines the generic PostGIS geometry type (geometry(Geometry,[SRID])) although in the feature type properties (of the writer) the parameter "Geometry" is set to "From Schema Definition" or to "First Feature Defines Geometry Type". I need that the specific geometry types from the reader (Point, Line, Polygon...) are preserved because QGIS has problems with the generic PostGIS geometry type (duplicate entries when you try to add PostGIS layers).
Is there a workaround to make the writer define the correct geometry types apart from defining the whole workspace in static mode (what is not really an option because the table schemata can change in production)?
Any suggestions are very welcome.
