[GENERAL] Re: How to execute 'set session role' from plpgsql function?

Thanks. You suggestion helped me to find a solution!

DECLARE
...
query text;
BEGIN
....
query := query :='SET SESSION ROLE ' || wishedrole;
EXECUTE query;
......

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general