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

RESET

Restores the value of a configuration parameter to its default value.

You can reset either a single specified parameter or all parameters at once. To set a parameter to a specific value, use the SET command. To display the current value of a parameter, use the SHOW command.

Syntax

Copy
RESET { parameter_name | ALL }

Parameters

parameter_name

Name of the parameter to reset. See Modifying the Server Configuration for more documentation about parameters.

ALL

Resets all run-time parameters.

Examples

The following example resets the query_group parameter to its default value:

Copy
reset query_group;

The following example resets all run-time parameters to their default values:

Copy
reset all;

On this page: