PostGIS_Version — Returns PostGIS version number and compile-time options.
text PostGIS_Version();
text PostGIS_Version(
)
Returns PostGIS version number and compile-time options.
SELECT PostGIS_Version();
3.4 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
PostGIS_Full_Version, PostGIS_GEOS_Version, PostGIS_Lib_Version, PostGIS_LibXML_Version, PostGIS_PROJ_Version