Skip to content

SET

Set the value of a configuration parameter.

SET [ SESSION | LOCAL ] parameter { TO | = } { value | 'value' | DEFAULT }
SESSION
Set the value for the duration of the current session.
LOCAL
Set the value for the duration of the current transaction.

Note: SET SCHEMA 'value' is equivalent to SET search_path TO value, but you can only specify one schema with the SET SCHEMA syntax.

Some parameters cannot be changed at the session or local level.

See also the RESET, ALTER SYSTEM, ALTER ROLE, and SHOW commands.

Examples

Set the search_path:

premdb=# create schema premier;
CREATE SCHEMA
premdb=# create schema league;
CREATE SCHEMA
premdb=# set search_path to premier, league;
SET
premdb=# show search_path;
   search_path   
-----------------
 premier, league
(1 row)

Set the application_name parameter. For example:

premdb=# set application_name to ybsql_yb100;
SET

Setting the application name is useful for workload management configuration. For example, you can create WLM rules that refer to the application name in a condition.

Parent topic:SQL Commands