To get the PostgreSQL server version

If we experience problems, we need to double check the version of PostgreSQL server. It will help us to report a fault or consult the correct version of manual.

To get the PostgreSQL server version using psql shell:

edb=# select version();
version
——————————————————————————————————————-
EnterpriseDB 9.4.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-55), 64-bit
(1 row)

edb=# show server_version;
server_version
—————-
9.4.1.3
(1 row)

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by k2schools