Hello,
PostGIS is an excellent solution for handling complex geospatial data.
However, SharePoint does not natively support direct integration with PostGIS. You would need to expose your PostGIS data through a service, like GeoServer or ArcGIS Server, and then integrate those services into SharePoint using custom web parts or apps.
Another option: Microsoft Power BI integrates with SharePoint and can handle complex geospatial data as well. You can embed Power BI reports in SharePoint.
Best Regards,