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

From William Sescu (Suva)
Subject 3 Parameters in pg_settings in CamelCase
Date
Msg-id 254bc57bf034482aa0e1357221ce96b6@suva.ch
Whole thread Raw
Responses Re: 3 Parameters in pg_settings in CamelCase
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'

 

 

Cheers

William




Disclaimer:

Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.

This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Attachment

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z"
Next
From:
Date:
Subject: Data Type to store Leading Zero(0)