Re: 3 Parameters in pg_settings in CamelCase - Mailing list pgsql-admin

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'