postgresql - Convert all records in postgres to Titlecase, first letter uppercase

Question

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?

Answer 1

There 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