PostGIS_Version — Returns PostGIS version number and compile-time options.
text PostGIS_Version();
Returns PostGIS version number and compile-time options.
SELECT PostGIS_Version();
postgis_version
---------------------------------------
3.4 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
(1 row)