PostgreSQL UPPER Function

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

PostgreSQL UPPER() function

UPPER() function

The PostgreSQL upper function is used to convert a string from lower case to upper case.

Syntax :

upper(string)

PostgreSQL Version : 9.3

Pictorial Presentation of PostgreSQL UPPER() function

Example : PostgreSQL UPPER() function :

In the following example PostgreSQL upper function returns lower case to uppercase.

SELECT upper('w3resource');

Output :

   upper
------------
 W3RESOURCE
(1 row)

PostgreSQL UPPER() function using Column :

If we want to display the employee_id, first name, and first_name in upper case for those employees who belong to the department which department_id is 100 from employees table , the following SQL can be executed:

SELECT employee_id,first_name, 
upper(first_name) "Upper case of first_name" 
FROM employees 
WHERE department_id=100;

Output :

 employee_id | first_name  | Upper case of first_name
-------------+-------------+--------------------------
         108 | Nancy       | NANCY
         109 | Daniel      | DANIEL
         110 | John        | JOHN
         111 | Ismael      | ISMAEL
         112 | Jose Manuel | JOSE MANUEL
         113 | Luis        | LUIS
(6 rows)