Wouldnt you need to connect to the database first before you can ALTER ROLE anything?
On Tue, Feb 16, 2021 at 1:25 AM Wolfgang Walther <walt...@technowledgy.de> wrote: > Hi, > > I'm trying to set a GUC for a role in the current database only - but > don't know the name of the database at the time of writing code. Could > be development, staging, ... > > I would basically like to do something like this: > > ALTER ROLE a IN CURRENT DATABASE SET b TO c; > > Although that syntax doesn't exist (yet). > > I think I could wrap it in a DO block and create the statement > dynamically. Alternatively, I could probably INSERT INTO / UPDATE > pg_db_role_setting manually? > > Any other ideas how to achieve this easily? Does the proposed "IN > CURRENT DATABASE" syntax sound useful to anyone else? > > Best, > > Wolfgang > > > -- Abdul Qoyyuum Bin Haji Abdul Kadir HP No: +673 720 8043
