Re: 3 Parameters in pg_settings in CamelCase
От | Ian Lawrence Barwick |
---|---|
Тема | Re: 3 Parameters in pg_settings in CamelCase |
Дата | |
Msg-id | CAB8KJ=hDsqCfR+aMfzNyO3i+ARozKJF8DC=1XzoWeDL73vqcQw@mail.gmail.com обсуждение исходный текст |
Ответ на | 3 Parameters in pg_settings in CamelCase ("William Sescu (Suva)" <william.sescu@suva.ch>) |
Список | pgsql-admin |
2021年1月20日(水) 17:56 William Sescu (Suva) <william.sescu@suva.ch>:
Hello %
Is there any particular reason why 3 parameters out of 326 (in PostgreSQL 12.4) are in CamelCase?
At least when you query from pg_settings.
(postgres@[local]:55000)[postgres]> select name from pg_settings order by name;
name
----------------------------------------
…
…
DateStyle
IntervalStyle
TimeZone
…
…
All others are in lowercase. Even in the postgresql.conf these parameters are in lowercase.
$ cat postgresql.conf | egrep -i '(datestyle|intervalstyle|timezone)'
datestyle = 'iso, mdy'
#intervalstyle = 'postgres'
timezone = 'Europe/Zurich'
I think the simple answer is "because they've always been like that" (at least since PostgreSQL 7.3 [*])
and no-one has cared enough to change them.
Regards
Ian Barwick
EnterpriseDB: https://www.enterprisedb.com
В списке pgsql-admin по дате отправления: