Posted by Rex in 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
Follow the reactions below and share your own thoughts.
SQL Server 2012: Find Expiry Date of SQL serverIf you have installed SQL server 2012 Enterprise Evaluation Edition, this trial software will expire after 180 days without any pre alert notification. This SQL query will show the ... 
SQL Server 2005: What Service Pack is Installed?If you're running SQL Server, it's very wise to make sure that you have the latest service pack installed for optimum performance. If you're not sure what service pack ... 
Ubuntu: What Version am I Running?Not sure what version of Ubuntu is on your system(s)? You can find this info easily via the GUI or the terminal. Here's how: To display the version from ... 
What version(s) of the .NET Framework are installed on my PC?If you aren't sure which version(s) of the Microsoft.NET Framework are loaded on your PC, it can be a daunting task to find the desired info if you don't ... SQL Server 2012: Find Expiry Date of SQL serverIf you have installed SQL server 2012 Enterprise Evaluation Edition, this trial software will expire after 180 days without any pre alert notification. This ... SQL Server 2005: What Service Pack is Installed?If you're running SQL Server, it's very wise to make sure that you have the latest service pack installed for optimum performance. If you're ... 