Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
Date
Msg-id CAKFQuwbA+AXMZjALTAkRXviHEEE7bQsRtLaErTaSkY+Zm3RmEA@mail.gmail.com
Whole thread Raw
In response to Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION  (keypey@duck.com)
List pgsql-admin
Tree view
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. 

pgsql-admin by date:

Previous
From: keypey@duck.com
Date:
Subject: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
Next
From: keypey@duck.com
Date:
Subject: Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION