enable_case_sensitive_super_attribute

Values (default in bold)

true, false

Description

A configuration value that determines whether navigating SUPER data type structures with non-delimited attribute names is case sensitive. When you set enable_case_sensitive_super_attribute to true, navigating SUPER type structures with non-delimited attribute names is case sensitive. When you set the value to false, navigating SUPER type structures with non-delimited attribute names is not case sensitive.

When you enclose an attribute name in double quotation marks and set enable_case_sensitive_identifier to true, case is always preserved, regardless of the setting of the enable_case_sensitive_super_attribute configuration option.

enable_case_sensitive_super_attribute only applies to columns with the SUPER data type. For all other columns, consider using enable_case_sensitive_identifier instead.

For more information on the SUPER data type, see SUPER type and Semistructured data in Amazon Redshift.

Examples

The following example shows the results of selecting SUPER values with enable_case_sensitive_super_attribute enabled and with it disabled.

--Create a table with a SUPER column.
CREATE TABLE tbl (col SUPER);
 
--Insert values.
INSERT INTO tbl VALUES (json_parse('{
 "A": "A", "a": "a"
}'));

SET enable_case_sensitive_super_attribute TO ON;

SELECT col.A FROM tbl;
  a 
----- 
 "A"
(1 row)

SELECT col.a FROM tbl;
  a 
----- 
 "a"
(1 row)

SET enable_case_sensitive_super_attribute TO OFF;

SELECT col.A FROM tbl;
  a 
-----
 "a"
(1 row)

SELECT col.a FROM tbl;
  a  
-----
 "a"
(1 row)

Usage Notes