Expand description
Configuration parameters: their definitions and values, and the lifetimes of SET, SET LOCAL and temporary function configuration over values the host retains.
Modules§
- arguments
- The value text of
SET name TO argument, ..., flattened asPostgreSQL’sflatten_set_variable_argsdoes: only a list parameter takes several arguments, which are joined with,, and a string of a quoted list is quoted as an identifier needs. - catalog
- The configuration parameters the engine defines, with the types, bounds, contexts and descriptions of
PostgreSQL18’sguc_tables.c, in the case-insensitive name order ofSHOW ALL. - custom
- Custom parameters: the names a session may set without a definition, which
PostgreSQLkeeps as string placeholders (assignable_custom_variable_name). - datestyle
DateStyleinput order and canonical assignments, including partial settings and reset defaults.- definition
- The definition of one configuration parameter as
PostgreSQL’sguc_tables.cdeclares it: its type and bounds, when a session may change it, and the descriptions thatpg_settingsandSHOW ALLreport. - identifier_
list - Identifier lists in parameter values, such as
search_path, split asPostgreSQL’sSplitIdentifierStringdoes. - setting
- One parameter’s value in a session, as
pg_settingsandSHOW ALLreport it. - units
- Integer parameter values and their units, read and shown as
PostgreSQL’sparse_int,convert_to_base_unitandconvert_int_from_base_unitdo: Cstrtolandstrtodnumber syntax, a unit of up to three characters, rounding to the nearest multiple of the next smaller unit, and display in the greatest unit that divides the value. - value
- Parameter values read and shown as
PostgreSQL’sparse_and_validate_valueandShowGUCOptiondo. A setting is kept as the textpg_settings.settingreports: an integer in base units,onoroff, the canonical name of an enumerated value, or the string itself.
Structs§
- Parameter
Scope - Parameter
Scopes - Values remain owned by the host; SQL decides which assignment lifetime restores them.