lower(str)

Returns a copy of string str with all cased characters converted to lowercase.

Example

This example returns the first five entries in the City column in lowercase.

SELECT lower(City) as "lCity"
FROM "Superstore"
GROUP BY City
LIMIT 5;
lCity
aberdeen
abilene
akron
albuquerque
alexandria