PostgreSQL LOWER
From w3cyberlearnings
Contents |
Postgresql lower
Converts string to lower case.
Syntax lower
lower()
Example 1
test2=# SELECT lower('APPLE');
lower
-------
apple
(1 row)
Example 2
test2=# SELECT user_firstname,
test2-# lower(user_firstname)
test2-# FROM profile;
user_firstname | lower
----------------+-------
Jim | jim
king | king
Jammi | jammi
Bob | bob
|
(5 rows)
