PostgreSQL UPPER
From w3cyberlearnings
Contents |
Postgresql upper
This function converts string to all upper case.
Syntax upper
upper(string)
Example 1
test2=# SELECT upper('apple');
upper
-------
APPLE
(1 row)
Example 2
test2=# SELECT user_firstname,
test2-# upper(user_firstname)
test2-# FROM profile;
user_firstname | upper
----------------+-------
Jim | JIM
king | KING
Jammi | JAMMI
Bob | BOB
|
(5 rows)
