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