I add to my
%n parameter to show the current user. I thought that it works like
SELECT CURRENT_USER; but when I changed my role with
SET ROLE role_name; I noticed that user in my prompt doesn't changed but in
CURRENT_USER is role name as I expected.
Is there any way to display in prompt the current role instead of current user?