`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.

1SELECT lower(City) as "lCity"
2FROM "Superstore"
3GROUP BY City
4LIMIT 5;