Hi, I am trying to find a way to set a role for the queries. I want to do this to use policies / row level security.

Is there a way to have a query like this?

set role $1;
select * from foo;