How To Change PostgreSQL User While Connected To The Database

After connecting to the database in PostgreSQL, you may want to change the user you are connected to.

You may want to read the article entitled “How To Connect To Database On PostgreSQL” for how to connect to PostgreSQL.

You can switch to the testuser user from the current user with the command below.

SET ROLE testuser;

1	SET ROLE testuser;

You can find the user you are connected to with the command below.

select current_user;

1	select current_user;

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