How to rename PostgreSQL User

In this article, We will see how to rename PostgreSQL User. ALTER ROLE is used for PostgreSQL rename User.

Permissions Required are:

• Database superusers can rename any role.
• Roles having CREATEROLE privilege can rename non-superuser roles.
• The current session user cannot be renamed.

Syntax to Rename PostgreSQL User:

ALTER ROLE name RENAME TO new_name 

PostgreSQL User rename examples:

1. Lets verify list of users by using either of queries.

\du

or

 select usename from pg_user;

Output:

postgres=# select usename from pg_user;

  usename
-----------
 karunakar
 james
 postgres
 elchuru
(4 rows)

2. From the above list, lets rename user ‘echuru’ to ‘salesadmin’ in PostgreSQL Server.

 ALTER ROLE elchuru RENAME TO salesadmin;

3. Lets verify the user after rename.

 postgres=# select usename from pg_user;
  usename
------------
 karunakar
 james
 postgres
 salesadmin
(4 rows)