postgresql show version code example

Example 1: check postgres version

psql --version

Example 2: check postgres version in ubuntu

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

Example 3: get postgres version

postgres -V
// or 
psql --version

Example 4: postgres version command

SELECT version();