On 5/20/20 1:28 PM, Adam Brusselback wrote:
> I have this exact setup, and I use roles / schema names that match so
> the $user var works with the search path when I set role as my
> application user.
>
> > When search_path contains “$user”, does it refer to session_user or
> current_user ?
> It uses current_user, not session_user. Works perfectly with set_role
> for me.
>
Am I (again) alone in finding this a bit hokey? That a user name just
happens to be a schema name ...