In order to convert the column to Uppercase in postgresql we use UPPER() function. UPPER function in postgresql converts string column to Uppercase. Let’s see how to
- Convert column to Uppercase in postgresql
Syntax of UPPER():
UPPER ()
We will be using states table.
Convert column to Uppercase in postgresql:
UPPER() function converts the column to Uppercase in postgresql
select *, UPPER(state_name) as Upper_state from states
We have converted the state_name column to Uppercase. So the resultant table will be,