On Thu, Mar 11, 2021, at 08:00, Joel Jacobson wrote: > 0004-pg_permissions-and-pg_ownerships.patch
Having gotten some hands-on experience of these views for a while, I notice I quite often want to check the ownerships/permissions for some specific type of objects, or in some specific schema. The current patch returns pg_describe_object() as the "objdesc" column. Would it be a better idea to instead return the fields from pg_identify_object()? This would allow specifically filtering on "type", "schema", "name" or "identity" instead of having to apply a regex/LIKE on the object description. /Joel
