Windows DatabaseebooksStatistical Information

LLE10256 : Howto find the exact PostgreSQL version you are running

Symptom:

You are using postgres sql and need the version

Cause:

none

Solution:

You just just use the following sql statement:

SELECT version();

The output will look like:


                                             version
-------------------------------------------------------------------------------------------------
 PostgreSQL 8.3.11 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2


In MS SQL (TSQL) you can use the following sql statement:

SELECT @@VERSION;

Disclaimer:

The information provided in this document is intended for your information only. Lubby makes no claims to the validity of this information. Use of this information is at own risk!
Copyright © 2004-2011 Lubby (V3.0.10 Aug 2011)
Sponsored by Keskon.
Statistical information by Google Analytics