Skip to content

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

Parent topic:String Functions