"Joel Jacobson" <j...@compiler.org> writes: > On Thu, Mar 25, 2021, at 16:16, Alvaro Herrera wrote: >> Ah, of course -- the only way to obtain the acl columns is by going >> through the catalogs individually, so it won't be possible. I think >> this could be fixed with some very simple, quick function pg_get_acl() >> that takes a catalog OID and object OID and returns the ACL; then >> use aclexplode() to obtain all those details.
> +1 for adding pg_get_acl(). I wonder what performance will be like with lots o' objects. regards, tom lane