LOWER

Return a character string in all lowercase letters.
LOWER(string)
For example:
premdb=# SELECT LOWER(name) FROM team;
          lower          
-------------------------
 arsenal
 aston villa
 barnsley
 birmingham city
 blackburn rovers
...