doc/user/content/sql/set.md
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.
SET [SESSION|LOCAL] <config> TO|= <value|DEFAULT>;
| Syntax element | Description |
|---|---|
| SESSION | Optional. Set the value for the duration of the current session. (Default) |
| LOCAL | Optional. If specified, set the value for the duration of a single transaction. |
<config> | The name of the configuration parameter to modify. |
<value> | The value to assign to the parameter. |
| DEFAULT | Use the parameter's default value. Equivalent to RESET. |
{{% include-headless "/headless/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.SHOW cluster;
cluster
---------
default
SET cluster = 'quickstart';
SHOW cluster;
cluster
------------
quickstart
SET transaction_isolation = 'serializable';
SET search_path = public, qck;
SET schema = qck;