PostGIS Reader should handle multiple geometry columns in a table

+1 Handling multiple geometries is a need.

I've encountered a bug when dealing with Postgis mutliple geometries table which requires to specify which geometry is taken into account, otherwise FME loses geometry :

https://github.com/qwat/qwat-data-model/issues/265

This may help:

https://knowledge.safe.com/articles/24702/handling-data-that-contains-multiple-geometry-colu.html

However yes, a more intuitive way would be greatly appreciated by many of us.

See also duplicate Idea: https://knowledge.safe.com/idea/117563/native-support-for-postgresql-multiple-geometry-co.html

One of the advantages of PostGIS is that it can handle multiple geometry columns in the same table. For example and a polygon area of interest, then the gradual erosion of that AOI which regard to image collection, etc. Should not have to choose one or the other, in my opinion.

I now too have this challenge whereby the table holds multiple geometries. Coming from Oracle Spatial and seeing how easy it works with FME I was surprised Safe has not implemented the same for PostGIS

I realise this idea relates to the PostGIS Reader, but it would also be good if PostGIS Writer could write to multiple geometry columns.

I tried the workaround at https://community.safe.com/s/article/template-write-multiple-geometry-types-to-an-exist, but writing the second geometry column is extremely slow, as bulk insert for this writer is switched off during translation (the following warning message is received):

POSTGIS Writer: Bulk Insert is set to Yes, but a conflicting Feature Operation has been detected. Feature type 'rc_srb.srb_01' has a Feature Operation of 'Update'. Bulk Insert is now being set to No, which can cause insert operations to be much slower

As a result, the timings for writing a dataset of 130,000 features is as follows:

• 1st geometry column – 1 minute
• 2nd geometry column – 42 minutes

Hi all,

In FME 2026.3, I’m pleased to let you know that the PostGIS Reader and Writer now handle multiple geometry natively.

For more details on how to work with multiple geometry, please check out this article here.

Hi ​@andreaatsafe, that’s a wonderfull news !

Will try it ASAP

Thanks