PostgreSQL – PostGIS versions

Login to your postgresql on some database and go:

To get PostgreSQL version:

SELECT version();

To get versions for PostGIS, GEO, etc.:

SELECT PostGIS_full_version();