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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "keypey(at)duck(dot)com" <keypey(at)duck(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
Date: 2024-09-04 13:15:12
Message-ID: CAKFQuwbA+AXMZjALTAkRXviHEEE7bQsRtLaErTaSkY+Zm3RmEA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message keypey 2024-09-04 13:25:30 Re: Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION
Previous Message keypey 2024-09-04 12:50:25 Assign TEXT/NAME variable type to SET SESSION AUTHORIZATION