Re: [GENERAL] Backward compatibility
| От | David G. Johnston |
|---|---|
| Тема | Re: [GENERAL] Backward compatibility |
| Дата | |
| Msg-id | CAKFQuwaNm8Su+UZj85wLrd4D5k=ys1-aF5k4mtmHLS_UYovL8Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] Backward compatibility (Igor Korot <ikorot01@gmail.com>) |
| Ответы |
Re: [GENERAL] Backward compatibility
|
| Список | pgsql-general |
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
see the below for other ways to query the setting.
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.
В списке pgsql-general по дате отправления: