Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

find Version and Release Information

In this post, I am sharing basic commands to check the PostgreSQL version information.
PostgreSQL Database Administrator can use this command to find the version number, release version name of PostgreSQL.
During the migration activities, we require to check the numeric version number instead of a full version name.
At that time, we can use below commands to get the numeric version number.
First, Get PostgreSQL Version name:
SELECT VERSION();
 
/* Sample Result:
version
--------------------------------------------------------------------------
PostgreSQL 9.5.3, compiled by Visual C++ build 1800, 32-bit
*/


Get only PostgreSQL Version:

SHOW SERVER_VERSION;
 
/*Sample Result:
server_version
-----------------------
9.5.3
*/

Get PostgreSQL Version Number:

SELECT current_setting('server_version_num');
 
/* Sample Result:
current_setting
-------------------------
90503
*/

Comments

Popular posts from this blog

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

What's is the difference between streaming replication Vs hot standby vs warm standby ?

Script to kill ALL IDLE Connection In postgreSQL