Get PostGIS version

Question

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

score 351 · Accepted Answer · edited Mar 28 '13 at 20:19

351

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

edited Mar 28 '13 at 20:19

Brad Koch

19,267
19
110
137

answered Jan 28 '11 at 22:34

Nicklas Avén

4,706
1
18
15

score 35 · Answer 2 · edited May 15 '13 at 15:52

35

Did you try using SELECT PostGIS_version();

edited May 15 '13 at 15:52

juliomalegria

24,229
14
73
89

answered Jan 28 '11 at 21:48

Jon Conley

451
3
4

10

Caution: `PostGIS_version()` outputs the major and minor version (e.g., "2.1"), but not the revision number (e.g., "2.1.4"), like `PostGIS_full_version()` and `PostGIS_Lib_Version()` do. – Sean the Bean Jan 26 '15 at 17:59

score 16 · Answer 3 · edited Sep 28 '12 at 18:16

16

PostGIS_Lib_Version(); - returns the version number of the PostGIS library.

http://postgis.refractions.net/docs/PostGIS_Lib_Version.html

edited Sep 28 '12 at 18:16

andrewsi

10,807
132
35
51

answered Aug 31 '12 at 07:34

tino

221
3
4

score 12 · Answer 4 · answered Feb 06 '12 at 16:54

As the above people stated, select PostGIS_full_version(); will answer your question. On my machine, where I'm running PostGIS 2.0 from trunk, I get the following output:

postgres=# select PostGIS_full_version();
postgis_full_version                                                                  
-------------------------------------------------------------------------------------------------------------------------------------------------------
POSTGIS="2.0.0alpha4SVN" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.7.1, 23 September 2009" GDAL="GDAL 1.8.1, released 2011/07/09" LIBXML="2.7.3" USE_STATS
(1 row)

You do need to care about the versions of PROJ and GEOS that are included if you didn't install an all-inclusive package - in particular, there's some brokenness in GEOS prior to 3.3.2 (as noted in the postgis 2.0 manual) in dealing with geometry validity.

score 10 · Answer 5 · answered Jun 27 '16 at 12:38

10

Other way to get the minor version is:

SELECT extversion
FROM pg_catalog.pg_extension
WHERE extname='postgis'

answered Jun 27 '16 at 12:38

Matias Barone

168
1
8

The above methods gave me `No function matches the given name and argument types. You might need to add explicit type casts.` but this one worked. The problem with the above not working was fixed by doing the `CREATE EXTENSION Postgis` from the console rather than from the db-migrate.js – Eric Darchis Sep 16 '16 at 09:55

score 2 · Answer 6 · answered May 23 '22 at 08:57

2

Using SELECT PostGIS_version();

answered May 23 '22 at 08:57

Leo

121
1
5

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – lemon May 23 '22 at 11:00

score 1 · Answer 7 · answered Mar 16 '22 at 01:47

1

Using: SELECT PostGIS_full_version();

answered Mar 16 '22 at 01:47

Viettel Solutions

1,519
11
22

Get PostGIS version

7 Answers7

Linked