Abdul Qoyyuum:
Wouldnt you need to connect to the database first before you can ALTER
ROLE anything?
Of course, otherwise the notion of "current database" wouldn't make
sense at all. But that's only before executing the code. I am not
writing and executing this code at the same time.
In my
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
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
>
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 d
