Postgres Pro
Downloads
Home   >   mailing lists

Re: How to determine server version inside select statement - Mailing list pgsql-general

From Osvaldo Kussama
Subject Re: How to determine server version inside select statement
Date
Msg-id AANLkTi=Fu5CqpA7f862oTbKAZce5_y1v6ahF20TFHkuM@mail.gmail.com
Whole thread Raw
In response to How to determine server version inside select statement  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: How to determine server version inside select statement
Next
From: Peter Neal
Date:
Subject: avoiding nested loops when joining on partitioned tables