PostgreSQL – How to Retrieve the Current User
You can retrieve the username of the currently logged-in user using the current_user
function.
SELECT current_user;
When you execute this SQL query, it will return the username of the currently logged-in user as a text value. You can use this information in your SQL queries or as part of your application to determine the current user’s identity and apply access control or auditing as needed.
For example, you can use it in a query to find records associated with the current user:
SELECT * FROM your_table WHERE user_id = current_user;
This query retrieves records from your_table
where the user_id
matches the currently logged-in user’s username.