I have a simple table in PostgreSQL called keywords with a simple text field called name. I want to convert all names of keywords in first letter uppercase. Is there a way to do it from psql console?
See Question&Answers more detail:osI have a simple table in PostgreSQL called keywords with a simple text field called name. I want to convert all names of keywords in first letter uppercase. Is there a way to do it from psql console?
See Question&Answers more detail:osThere is an initcap()
function, if you're meaning to uppercase the first letter of each keyword and to lowercase the following characters:
update foo
set bar = initcap(bar)
Else combine substring()
and upper()
:
update foo
set bar = upper(substring(bar from 1 for 1)) ||
substring(bar from 2 for length(bar))
http://www.postgresql.org/docs/current/static/functions-string.html