Am 26.04.23 um 19:53 schrieb richard coleman:
> Erik,
>
> Thanks for that. I'll have to look into the aclexplode() function
> some more.
>
> When I try running your SQL on a pg11 database I get:
>
> ERROR: role "role" does not exist
> LINE 3: WHERE grantee = 'role'::regrole AND privilege_type I...
> ^
> SQL state: 42704
> Character: 151
>
> rik.
>
If you want to use the SQL statements used by psql on older versions of
PostgreSQL, you should use the old version of psql.
>
>
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012