Convert column to Uppercase in Postgresql

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 1

 

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

convert column to Uppercase in postgresql 2