Saturday , April 27 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

How to Change User Name in PostgreSQL

Faruk Erdem November 2, 2018 MSSQL

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;