Обсуждение: Re: How to execute 'set session role' from plpgsql function?

Поиск
Список
Период
Сортировка

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

От
Oleg Vasylenko
Дата:
 Thanks. You suggestion helped me to find a solution!

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