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


Values (Default in Bold)

off (false), on (true)


Specifies whether column names returned by SELECT statements are uppercase or lowercase. If on, column names are returned in uppercase. If off, column names are returned in lowercase. Amazon Redshift stores column names in lowercase regardless of the setting for describe_field_name_in_uppercase.


set describe_field_name_in_uppercase to on; show describe_field_name_in_uppercase; DESCRIBE_FIELD_NAME_IN_UPPERCASE -------------------------------- on