I am looking for an instruction to execute SQL block with elevate permitions.

I would like to know if exists how to execute pSQL as another role (or user) or SQL update/insert/delete.

I found 'set role' in docs, but in my test case does not run in PSQL (execute block).

I can change role in my app, but it will drop/open connection.

If there is a 'run as' in pSQL/SQL then I will prefer this method.

Thanks a lot.