SET_CONFIG_PARAMETER
Sets or clears a configuration parameter at the specified level.
Sets or clears a configuration parameter at the specified level.
Important
You can only use this function to set configuration parameters with string or integer values. To set configuration parameters that accept other data types, use the appropriate ALTER statement.This is a meta-function. You must call meta-functions in a top-level SELECT statement.
Behavior type
VolatileSyntax
SET_CONFIG_PARAMETER( 'param-name', { param-value | NULL}, ['level'| NULL])
Arguments
param-name- Name of the configuration parameter to set. See Configuration parameters for details on supported parameters and valid settings.
param-value- Value to set for
param-name, either a string or integer. If a string, enclose in single quotes; if an integer, single quotes are optional.To clear
param-nameat the specified level, set to NULL. level- Level at which to set
param-name, one of the following string values:-
user: Current user. -
session: Current session, overrides the database setting. -
node-name: Name of database node, overrides session and database settings.
If
levelis omitted or set to NULL,param-nameis set at the database level. -
Note
Some parameters require restart for the value to take effect.Privileges
SuperuserExamples
Set the AnalyzeRowCountInterval parameter to 3600 at the database level:
=> SELECT SET_CONFIG_PARAMETER('AnalyzeRowCountInterval',3600);
SET_CONFIG_PARAMETER
----------------------------
Parameter set successfully
(1 row)
Note
You can achieve the same result with ALTER DATABASE:
ALTER DATABASE DEFAULT SET PARAMETER AnalyzeRowCountInterval = 3600;
Set the MaxSessionUDParameterSize parameter to 2000 at the session level.
=> SELECT SET_CONFIG_PARAMETER('MaxSessionUDParameterSize',2000,'SESSION');
SET_CONFIG_PARAMETER
----------------------------
Parameter set successfully
(1 row)