PostgreSQL - How to show the running version?

If you want to know which version of PostgreSQL you are running, these are some common ways to find out.

1. Using psql

With psql, use command -V:

$ psql -V

2. Using Query editor

With Query Editor, you can run:

SELECT version();

or

SHOW server_version;

3. Using TablePlus

In TablePlus, the version of PostgreSQL is shown on the status bar

---

Need a good GUI tool for PostgreSQL? Check out TablePlus. It’s native, beautiful, and available for free.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS