Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION - Mailing list pgsql-admin

From keypey@duck.com
Subject Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
Date
Msg-id 3833395F-7F7F-4862-8D42-104FC9ABCB66.1@smtp-inbound1.duck.com
Whole thread Raw
In response to Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION  (keypey@duck.com)
List pgsql-admin

David
Thanks a lot!

--

kp


śr., 4 wrz 2024 o 15:15 David G. Johnston <david.g.johnston_at_gmail.com_keypey@duck.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.
On Wednesday, September 4, 2024, <keypey@duck.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.,

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
Next
From: Sam Stearns
Date:
Subject: Book