PostgreSQL - check version using SQL

0 points
Created by:

In this short article, we would like to show how to check the PostgreSQL version using SQL.

Quick solution:

SELECT version()

Example output:

PostgreSQL 13.2, compiled by Visual C++ build 1914, 64-bit

Another solution:

SHOW server_version;

Example output:

Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Join to our subscribers to be up to date with content, news and offers.

PostgreSQL - problems

PostgreSQL - check version using SQL
Native Advertising
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂