Check PostgreSQL Version Command

Check PostgreSQL version using command-line:

$ psql --version

Check PostgreSQL version in Ubuntu:

$ locate bin/postgres
/usr/lib/postgresql/9.3/bin/postgres

Get PostgreSQL version using command-line:

$ postgres -V

PostgreSQL version command using SQL client:

SELECT version();

Found this article interesting? Follow Brightwhiz on Facebook, Twitter, and YouTube to read and watch more content we post.