How to Convert the Case of a String

PostgreSQL provides several case related functions as we can see in the following SQL example:

select lower(‘jaMES’) , upper(‘jaMES’), initcap(‘jaMES’);
lower upper initcap
james JAMES James

IN THIS PAGE