How to Change User Name in PostgreSQL

Faruk Erdem

6 years ago

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.

ALTER USER  old_name RENAME TO new_name;

1	ALTER USER old_name RENAME TO new_name;