Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

SET_CONFIG

Sets a configuration parameter to a new setting.

This function is equivalent to the SET command in SQL.

Syntax

Copy
set_config('parameter', 'new_value' , is_local)

Arguments

parameter

Parameter to set.

new_value

New value of the parameter.

is_local

If true, parameter value applies only to the current transaction. Valid values are true or 1 and false or 0.

Return Type

Returns a CHAR or VARCHAR string.

Examples

The following query sets the value of the query_group parameter to test for the current transaction only:

Copy
select set_config('query_group', 'test', true); set_config ------------ test (1 row)