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:
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,