Black Friday 2023 at Serverspace. 50% cash back on Cloud Servers
September 27, 2023
Updated September 27, 2023

How to Check/Get PostgreSQL Version?

Databases Debian


In the modern DBMS system we can do quite everything with data and skills of operating are significant. In that tutorial we consider process of checking database system management version, that can help if you want to install additional software and check accordance for you set, realize which are functions available on your version and etc.

Check version

We already have installed DBMS PostgreSQL on our machine, first of all we switch user for postgres:

sudo -i -u postgres && psql
Screenshot №1 — Login

As you can see after entering command psql we have summary information about our version of using DBMS 15.3 and next information of operating system. But how we can see more details? Let's type command below:

SELECT version();

Highlight! After most requests we need to type semicolon as a sing end of request.

Version of DB
Screenshot №2 — Version of DB

For exit you can type command:


Or just kill process by button combination Ctrl+Z

Screenshot №3 — Exit


This tutorial has shed light on the importance of understanding and managing the version of a Database Management System (DBMS). In the realm of modern DBMS systems, having the skills to operate and navigate through the system efficiently is paramount. The ability to check the version of your DBMS serves multiple purposes, from ensuring compatibility when installing additional software to knowing which features are available in your specific version.

5 out of 5
Аverage rating : 5
Rated by: 1
33145 North Miami, FL, United States 2520 Coral Way apt 2-135
+1 302 425-97-76
700 300
700 300

You might also like...

We use cookies to make your experience on the Serverspace better. By continuing to browse our website, you agree to our
Use of Cookies and Privacy Policy.