---
title: "How to know? Which version of PostgreSQL am I running?"  
description: "How to know? Which version of PostgreSQL am I running?"  
author: "Utpal Vishwas"  
published: 2023-07-14  
updated: 2023-07-15  
canonical: https://www.mindstick.com/forum/159092/how-to-know-which-version-of-postgresql-am-i-running  
category: "postgresql"  
tags: ["sql", "postgresql"]  
reading_time: 2 minutes  

---

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

How to know? Which [version](https://www.mindstick.com/articles/12845/things-to-remember-while-migrating-odoo-to-a-better-version) of [PostgreSQL](https://answers.mindstick.com/qa/92847/what-is-postgresql) am I running?

## Replies

### Reply by Aryan Kumar

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:

```plaintext
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:

```plaintext
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.


---

Original Source: https://www.mindstick.com/forum/159092/how-to-know-which-version-of-postgresql-am-i-running

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.