PostgreSQL INITCAP
From w3cyberlearnings
Contents |
Postgresql initcap
Converts all the first letter to upper case.
Syntax initcap
initcap(string)
Example 1
test2=# SELECT initcap('good man');
initcap
----------
Good Man
(1 row)
Example 2
test2=# SELECT initcap(name)
test2-# FROM mytesttime WHERE id=7;
initcap
--------------------------------------
Great Wall Of China Is A Great Place
(1 row)
