Skip to main content

Module value

Module value 

Source
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.enumvals lists.
name_truncation_notice
The notice PostgreSQL raises before it truncates a GUC_IS_NAME string that is longer than an identifier.
parse_setting
Read raw as a value of definition and return the setting it stands for, or the error SET reports for it.
parse_setting_with_context
Read a setting with the session’s current and reset values for partial assignments.
show_setting
Show setting as SHOW and current_setting report it: an integer in the greatest unit that divides it.