convert string case

Sometimes you may need to convert lowercase to uppercase or uppercase to lowercase. Here is how to convert case of string in PostgreSQL