Hello ALL, 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.
