Sets a configuration parameter to a new setting.
This function is equivalent to the SET command in SQL.
Syntax
SET_CONFIG('parameter', 'new_value' , is_local)
The following statement sets a session context variable to a new setting.
set_config('variable_name', 'new_value' , is_local)
Arguments
- parameter
-
Parameter to set.
- variable_name
-
The name of the variable to set.
- new_value
-
New value of the parameter.
- is_local
-
If true, parameter value applies only to the current transaction. Valid values are
trueor1andfalseor0.
Return type
Returns a CHAR or VARCHAR string.
Examples
To set the value of the query_group parameter to
test for the current transaction only, use the following example.
SELECT SET_CONFIG('query_group', 'test', true);
+------------+
| set_config |
+------------+
| test |
+------------+To set session context variables, use the following example.
SELECT SET_CONFIG(‘app.username’, ‘cuddy’, FALSE);