PostgreSQL SET ROLE for schema browser and "Jump to Editor"

Answered

Is there a way to set the active role for the connection used by the schema explorer and/or the "jump to editor" context menu?

 

On PostgreSQL many of our tables require the user be a member of a specific group role, especially FWD tables. This is a different group role than the users login role.

 

In an interactive session I would "SET ROLE powerusers;" but I have not been able to find a way to achieve this for the schema browser' or table editor connections.

 

Thanks

/g

1 comment
Comment actions Permalink

I created an issue based on your description DBE-6577

0

Please sign in to leave a comment.