Thread: How to determine server version inside select statement

I tried

SELECT (SHOW server_version) AS Contents

but got

ERROR:  syntax error at or near "server_version" at character 14


how to get server version inside select statement ?

Andrus.

2010/10/31 Andrus <kobruleht2@hot.ee>:
> I tried
>
> SELECT (SHOW server_version) AS Contents
>
> but got
>
> ERROR:  syntax error at or near "server_version" at character 14
>
>
> how to get server version inside select statement ?
>


SELECT current_setting('server_version') AS Contents;

Osvaldo

On 31 Oct 2010, at 22:56, Andrus wrote:

> I tried
>
> SELECT (SHOW server_version) AS Contents


postgres=> select version();
                                                 version

--------------------------------------------------------------------------------
-------------------------
 PostgreSQL 8.4.4 on i386-portbld-freebsd7.2, compiled by GCC cc (GCC) 4.2.1 200
70719  [FreeBSD], 32-bit
(1 row)


Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4ccdfa2010261036599539!