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

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