On 2021-Mar-23, Joel Jacobson wrote: > 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.
For programmatic use it is certainly better to use the object identity rather than the description. Particularly because the description gets translated, and the identity doesn't. -- Álvaro Herrera Valdivia, Chile
