postgresql version check 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: postgresql version command

# SSH
psql --version
# SQL
SELECT version();

Example 5: postgres version command

SELECT version();