You have created a user in Postgresql, but software developer ask for change the user name or you have to change it for different reasons.
You do not need to delete and re-create the user, you can change the user name using the command below.
1 | ALTER USER old_name RENAME TO new_name; |