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