UPPER

Return a character string in all uppercase letters.
UPPER(string)

For example:

premdb=# SELECT UPPER(name) FROM team;
          upper          
-------------------------
 ARSENAL
 ASTON VILLA
 BARNSLEY
 BIRMINGHAM CITY
 BLACKBURN ROVERS
...