Expand description
Parameter values read and shown as PostgreSQL’s parse_and_validate_value and ShowGUCOption do. A setting is kept as the text pg_settings.setting reports: an integer in base units, on or off, the canonical name of an enumerated value, or the string itself.
Functions§
- invalid_
value_ message invalid value for parameter "name": "value", the message of a value that does not parse or that a check rejects.- listed_
enum_ values - The names of an enumerated parameter’s values that
pg_settings.enumvalslists. - name_
truncation_ notice - The notice
PostgreSQLraises before it truncates aGUC_IS_NAMEstring that is longer than an identifier. - parse_
setting - Read
rawas a value ofdefinitionand return the setting it stands for, or the errorSETreports for it. - parse_
setting_ with_ context - Read a setting with the session’s current and reset values for partial assignments.
- show_
setting - Show
settingasSHOWandcurrent_settingreport it: an integer in the greatest unit that divides it.