Get PostGIS version

Question

How can I find out which version of PostGIS I have?

Answer 1

Since some of the functions depend on other libraries like GEOS and proj4 you might want to get their versions too. Then use:

SELECT PostGIS_full_version();