On 31 Oct 2010, at 22:56, Andrus wrote:
> I tried
>
> SELECT (SHOW server_version) AS Contents
postgres=> select version();
version
2010/10/31 Andrus :
> 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
--
Sent via pgsq
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
