How to know? Which version of PostgreSQL am I running?

Question

Aryan Kumar · Answer

Sure, there are a few ways to know which version of PostgreSQL you are running.

Using the psql command

One way to check the version of PostgreSQL you are running is to use the psql command. The psql command is a command-line tool that can be used to interact with a PostgreSQL database.

To check the version of PostgreSQL you are running, open a command prompt and run the following command:

psql -V

This will display the version of PostgreSQL that you are running.

Using the pg_version function

Another way to check the version of PostgreSQL you are running is to use the pg_version function. The pg_version function is a function that returns the version of PostgreSQL that is running.

To check the version of PostgreSQL you are running, open a PostgreSQL session and run the following command:

SELECT pg_version();

This will return the version of PostgreSQL that you are running.

Using the pgAdmin tool

If you are using the pgAdmin tool, you can check the version of PostgreSQL you are running by opening the pgAdmin tool and expanding the Servers tree.

In the Servers tree, right-click the server that you want to check the version for and select Properties. In the Properties dialog box, the version of PostgreSQL that you are running will be displayed in the Version property.

forum

How to know? Which version of PostgreSQL am I running?

Can you answer this question?

1 Answers