New answers tagged


As far as I was able to test with , SET ROLE role_name can also be achieved using a set_config function, e.g. SELECT set_config('role', 'role_name', TRUE), and this way parameters can be used: SELECT set_config($1, $2, TRUE). There is also a note in Postgres documentation that set_config provides the same functionality as SET (but even if ROLE is not ...

Top 50 recent answers are included