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

 

                                                                                                           

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.