Home > APIs > YSQL > The SQL language > SQL statements >

SET

Synopsis

Use the SET statement to update a run-time control parameter.

Syntax

Grammar
Diagram

set ::= SET [ SESSION | LOCAL ] { configuration_parameter { TO | = } 
                                  { value | DEFAULT }
                                  | TIME ZONE 
                                    { timezone | LOCAL | DEFAULT } }

set

Semantics

Although the values of a parameter can be set, displayed, and reset, the effect of these parameters are not yet supported in YugabyteDB. The default settings and behaviors will be used for the moment.

SESSION

Specify that the command affects only the current session.

LOCAL

Specify that the command affects only the current transaction. After COMMIT or ROLLBACK, the session-level setting takes effect again.

configuration_parameter

Specify the name of a mutable run-time parameter.

value

Specify the value of parameter.

SET