There a specific requirements where I need a geometry column in table to be flexible ( It can line or point or polygon or all of it )
Justification for requirements : main concern is to avoid the complexity of the having too many tables for each geometry type as we will be having many categories.
Possible solution I think can be are :
either use geometry column or create 3 different geom columns for point, line, polygon on single table
Has anyone been through this situation before ?
what will be possible pros and cons of each of above 2 implementation strategy ?