I've got a table with an RLS policy on it: Policies: POLICY "app_users_policy" USING ((app_id = CURRENT_USER)) Is there a way I'm not aware of (e.g. via Pl/PGSQL) that would allow "migration" of data from one RLS owner to another ? At the moment, the only option I can think of is for the external app to login as one user, cache the data and then login as the other user and re-save it. Basically the background is that I want to give users the ability to self-service migrate their existing app profile from "old" to "new" (the app being differentiated via RLS user on app_id)
