Display PostgreSQL/PgSQL version
Contributed by Rex 
Tagged: PostgreSQL PgSQL
To display the PostgreSQL version number (and other information like compiler version used to build PgSQL) issue the following SQL statement from within psql:
SELECT version();
To quickly determine just the PostgreSQL version number, run this command from the OS command line:
psql --version
You may also like -
Display the structure of PostgreSQL/PgSQL table fields
Display or show tables in a PostgreSQL/PgSQL database
SQL Server 2005: What Service Pack is Installed?
List the databases on a PostgreSQL/PgSQL server
Fix for ASP Pages That Will Not Display an ADO Recordset based on a #Temp Table
Ubuntu: What Version am I Running?
Solaris: list detailed package information with pkginfo
Cisco Switch 2900/2950: Display VLAN information