PostgreSQL: Rename a User

In this PostgreSQL post explains how to rename a user in PostgreSQL with syntax and examples.

Description

The ALTER USER statement is used to rename a user in the PostgreSQL database.

Syntax

The syntax to rename a user using the ALTER USER statement in PostgreSQL is:

ALTER USER user_name
  RENAME TO new_name;

Parameters or Arguments

user_name

The name of the user to rename in the PostgreSQL database.

new_name

The new name to assign to the user.

Note

• You can not rename the current session user. If you wish to rename the current session user, you will need to logout and then login as a different user to run the ALTER USER statement.

Example

Let's look at how to rename a user in PostgreSQL using the ALTER USER statement.

For example:

ALTER USER AODBA
  RENAME TO dbd;

In this example, the ALTER USER statement would rename the user called AODBA to dbd in the PostgreSQL database.