2021年1月20日(水) 17:56 William Sescu (Suva) <william.sescu@xxxxxxx>:
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
