PostGIS_Full_Version — Reports full postgis version and build configuration infos.
text PostGIS_Full_Version();
Reports full postgis version and build configuration infos. Also informs about synchronization between libraries and scripts suggesting upgrades as needed.