PostgreSQL – How to RESET ROLE of a User

ByAdmin

To revert to the original role of the logged in user, you can use the RESET ROLE statement. This will revert to the role of the logged-in user.

Here is the syntax of using the RESET ROLE command:

RESET ROLE;

I’m currently logged in as user ‘postgres’ as shown in the below screenshot:

Using the SET ROLE command, I’m going to assume admin_role as shown below:

I have now switched to admin_role as shown below:

Now, issuing the RESET ROLE command to revert to the original role of ‘postgres’.

Current role can be verified as shown below:

Similar Posts

PostgreSQL – How to Update Multiple Columns

ByAdmin

To update multiple columns in a PostgreSQL table, you can use the UPDATE statement. Below is the basic syntax for updating multiple columns: UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition; where Here’s an example of how to update multiple columns in a PostgreSQL table: Suppose you have a table named…

PostgreSQL – How to Get the First Day of Month From a Date

ByAdmin

To get the first day of the month from a date in PostgreSQL, you can use the DATE_TRUNC function. Here’s an example: SELECT DATE_TRUNC(‘month’, your_date_column) AS first_day_of_month FROM your_table; where your_date_column is the name of your date column and your_table is the name of your table. This query will return the first day of the…

PostgreSQL – How to Grant Superuser Privileges

ByAdmin

Superusers have full control over the database server and can perform any administrative task. Granting superuser privileges to a user should be done carefully, as it comes with significant power and responsibility. To grant superuser privileges to a user in PostgreSQL, follow these steps: Option 1: During PostgreSQL Installation Option 2: Using an Existing Superuser…