Materialize/doc/user/content/sql/set.md

---

title: "SET" description: "Modify the value of a configuration parameter in the current session." menu: main:

parent: 'commands'

---

SET modifies the value of a configuration parameter for the current session. By default, values are set for the duration of the current session.

To see the current value of a configuration parameter, use SHOW.

Syntax

{{< diagram "set-stmt.svg" >}}

Field	Use
name	The name of the configuration parameter to modify.
value	The value to assign to the parameter.
SESSION	(Default) Set the value for the duration of the current session.
LOCAL	Set the value for the duration of a single transaction.
DEFAULT	Use the parameter's default value. Equivalent to RESET.

{{% configuration-parameters %}}

Aliased configuration parameters

There are a few configuration parameters that act as aliases for other configuration parameters.

• schema: schema is an alias for search_path. Only one schema can be specified using this syntax. The TO and = syntax are optional.
• names: names is an alias for client_encoding. The TO and = syntax must be omitted.
• time zone: time zone is an alias for timezone. The TO and = syntax must be omitted.

Examples

Set active cluster

SHOW cluster;

 cluster
---------
 default

SET cluster = 'quickstart';

SHOW cluster;

  cluster
------------
 quickstart

Set transaction isolation level

SET transaction_isolation = 'serializable';

Set search path

SET search_path = public, qck;

SET schema = qck;

Related pages

• RESET
• SHOW