How to check the PostgreSQL version

PostgreSQL server version can be get from the PostgreSQL shell using the following query.

#SELECT version();

This will provide the full version and system information.

PostgreSQL client version can be get from the Linux shell itself using the following command.

#psql -V

This will provide the PostgreSQL client version.

That's all…