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

CURRENT_SETTING

CURRENT_SETTING returns the current value of the specified configuration parameter.

This function is equivalent to the SHOW command.

Syntax

Copy
current_setting('parameter')

Argument

parameter

Parameter value to display. For a list of configuration parameters, see Configuration Reference

Return Type

Returns a CHAR or VARCHAR string.

Example

The following query returns the current setting for the query_group parameter:

Copy
select current_setting('query_group'); current_setting ----------------- unset (1 row)