update the value with string replace in postgres query

Question

I have the table user and I want to replace the username field value from 'test user' as 'Test User'.

In update query for all username field values

update user set username='replace()'

Is it possible to do by query.

Zaynul Abadin Tuhin · Accepted Answer · 2020-09-02 08:44:37Z

6

use INITCAP

UPDATE user
SET username = INITCAP(username)

answered Sep 2, 2020 at 8:44

32.1k6 gold badges37 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1