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

Ora2PG - Oracle/MySQL to Postgres DB migration Version 20.0

spfile and pfile errors

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

How to Return a Result Set from a PostgreSQL Stored Procedure

PostgreSQL New version upgrade