SET_CONFIG_PARAMETER

Sets or clears a configuration parameter at the specified level.

This is a meta-function. You must call meta-functions in a top-level SELECT statement.

Behavior type

Syntax

SET_CONFIG_PARAMETER( 'param‑name', { param‑value | NULL}, ['level'| NULL])

Arguments

param‑name

Name of the configuration parameter to set.

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‑name at 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 level is omitted or set to NULL, param‑name is set at the database level.

Privileges

Examples

Set the AnalyzeRowCountInterval parameter to 3600 at the database level:

=> SELECT SET_CONFIG_PARAMETER('AnalyzeRowCountInterval',3600);
    SET_CONFIG_PARAMETER
----------------------------
 Parameter set successfully
(1 row)

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)

See also

• GET_CONFIG_PARAMETER
• CONFIGURATION_PARAMETERS