Re: SET ROLE and search_path

Rob Sargent <robjsargent@xxxxxxxxx> · Wed, 20 May 2020 13:32:49 -0600



    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 ...