Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION

David
Thanks a lot!

--

kp

śr., 4 wrz 2024 o 15:15 David G. Johnston <
david(dot)g(dot)johnston_at_gmail(dot)com_keypey(at)duck(dot)com> napisał(a):

> On Wednesday, September 4, 2024, wrote: _user := 'postgres'::name;end if;
> SET SESSION AUTHORIZATION _user::name;end;$body$;```---Unfortunately, I
> don't know how to convert it so that
> *DuckDuckGo* did not detect any trackers. More
> <https://duckduckgo.com/-FlJrDWmRvC6aB61K_vO3h5hJBFovO23anYwx1OQTF5ZP4Ua_XnuHMbQyiMwpRc9dlzYcsX9BjSCuZAcu6jYNZOoehDmBn1Ob31AlO4BgDofXMlxX70c811inupRcG1mphNZLG64IiKiA07hmUYkPLVZUS-EOKpmRGkcj4sWTD-5z_lS_ekC73tNXjru0H>
> Report Spam
> <https://duckduckgo.com/-FlJrDWmRvC6aB61K_vO3h5hJBFovO23anYwx1OQTF5ZP4Ua_XnuHMbQyiMwpRc9dlzYcsX9BjSCuZAcu6jYNZOoehDmBn1Ob31AlO4BgDofXMlxX70c811inupRcG1mphNZLG64IiKiA07hmUYkPLVZUS-EOKpmRGkcj4sWTD-5z_lS_ekC73tNXjru0H>
> On Wednesday, September 4, 2024, <keypey(at)duck(dot)com> wrote:
>
>>
>> _user := 'postgres'::name;
>> end if;
>>
>> SET SESSION AUTHORIZATION _user::name;
>> end;
>> $body$
>> ;
>> ```
>> ---
>> Unfortunately, I don't know how to convert it so that SET SESSION
>> AUTHORIZATION works properly.
>>
>>
> Dynamic SQL, I.e., the execute statement.
>
> David J.
>

--
kp.,