> On 26/04/2023 19:55 CEST Holger Jakobs <holger(at)jakobs(dot)com> wrote:
>
> Am 26.04.23 um 19:53 schrieb richard coleman:
>
> > ERROR: role "role" does not exist
> > LINE 3: WHERE grantee = 'role'::regrole AND privilege_type I...
> > ^
> > SQL state: 42704
> > Character: 151
>
> If you want to use the SQL statements used by psql on older versions of
> PostgreSQL, you should use the old version of psql.
'role'::regrole works perfectly fine since pg9.5 if the role exists.
Use grantee::regrole::text = 'role' to be safe.
--
Erik