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 Convert Date to Integer

ByAdmin

To convert a date to an integer in PostgreSQL, you can use the TO_CHAR function to format the date as a string and then cast it to an integer. Here’s an example: SELECT CAST(TO_CHAR(your_date_column, ‘YYYYMMDD’) AS INTEGER) AS date_integer FROM your_table; where The TO_CHAR function is used to format the date as a string with…

PostgreSQL – How to Get Month Name From a Date

ByAdmin

To get the month name from a date in PostgreSQL, you can use the TO_CHAR function with the appropriate format pattern. Here’s an example: SELECT TO_CHAR(your_date_column, ‘Month’) AS month_name FROM your_table; Replace your_date_column with the name of your date column and your_table with the name of your table. In this query, TO_CHAR is used to…

PostgreSQL – How to Concatenate Strings

ByAdmin

You can concatenate strings using the || operator or the CONCAT() function in PostgreSQL database. Here are examples of both methods: Using the || Operator: The || operator is used to concatenate two or more strings together. SELECT ‘Hello ‘ || ‘World’; You can also concatenate columns from a table: SELECT first_name || ‘ ‘…

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…