Functions / System Information Functions And Operators

version

Returns a string describing the PostgreSQL server's version.

Reading PG 18current·documented in 26 of 27 versions, 7.2 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

version () → text

Returns a string describing the PostgreSQL server's version. You can also get this information from server_version, or for a machine-readable version use server_version_num. Software developers should use server_version_num (available since 8.2) or PQserverVersion instead of parsing the text version.

Version history 5

12 → 13 changed
9.4 → 9.5 changed
7.4 → 8.0 changed
7.2 → 7.3 changed
7.1 → 7.2 added

Definition snapshot: b7bd9cda · English manual source