Convert column to Lowercase in Postgresql

In order to convert the column to lowercase in postgresql we use LOWER() function.  LOWER function in postgresql converts string column to lowercase. Let’s see how to

  • Convert column to lowercase in postgresql

Syntax of LOWER():

LOWER ()

We will be using states table.

convert column to Lowercase in postgresql 1

 

Convert column to lowercase in postgresql:

LOWER() function converts the column to lowercase in postgresql

select *, LOWER(state_name) as lower_state from states

we have converted the state_name column to lowercase . so the resultant table will be,

convert column to Lowercase 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.