Re: Backward compatibility

On Thu, Jul 20, 2017 at 7:13 PM, Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> Hi, ALL,
> According to the documentation PostgreSQL 9.6 (latest) supports
>
> CREATE INDEX IF NOT EXIST
>
> However, the version 9.4 and below supports only
>
> CREATE INDEX.
>
> Is there a query or a libpg function which can return the version of
> the server I'm running?
>

​SHOW server_version_num; -- this is better than "version()" since you
don't have to parse text

​
https://www.postgresql.org/docs/9.6/static/runtime-config-preset.html#GUC-SERVER-VERSION-NUM

see the below for other ways to query the setting.

https://www.postgresql.org/docs/9.6/static/config-setting.html#CONFIG-SETTING-SQL-COMMAND-INTERACTION

> And in the latter case - is there a way to check if the index exist?
>
> I guess I will have to query "information_schema" again...
>
>
​Yep, not much demand for multiple ways to do the same thing in this
area...​

​David J.​