> On 26/04/2023 19:55 CEST Holger Jakobs <holger@xxxxxxxxxx> 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
