Get PostGIS version

postgresql postgis
Jason Swett picture Jason Swett · Jan 28, 2011 · Viewed 104.2k times · Source

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

Answer

Nicklas Avén picture Nicklas Avén · Jan 28, 2011

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();

Related questions

good postgresql client for windows?

coming back to postgresql after several years of oracle ... what are the state-of-the art postgresql administrative/ddl generating/data inserting frontends on windows? it would be nice if it had integration for postgis as well. it should be standalone or …

Read More
Which data type for latitude and longitude?

I am newbie to PostgreSQL and PostGIS. I want to store latitude and longitude values in PostgreSQL 9.1.1 database table. I will calculate distance between two points, find nearer points by using this location values. Which data type should I use …

Read More
Postgis installation: type "geometry" does not exist

I am trying to create table with Postgis. I do it by this page. But when I import postgis.sql file, I get a lot of errors: ERROR: type "geometry" does not exist Does anybody know how can I fix …

Read More