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 Get Current and Next Values of Sequence

ByAdmin

You can use Sequences to generate unique integer values, often used as auto-incrementing primary keys in tables. You can obtain the current value and the next value of a sequence using the currval and nextval functions, respectively. These functions are typically used within SQL statements or in PL/pgSQL code. Current Value (currval): To get the…

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…