On 3/7/21 1:08 AM, Joel Jacobson wrote:
Attached is a suggestion of adding a convenience view,
allowing quickly looking up all objects owned by a given user.
This definitely seems like a useful feature. I know I am guilty of
creating tables as the wrong role more than one time.
Andreas
Hi,
Attached is a suggestion of adding a convenience view,
allowing quickly looking up all objects owned by a given user.
Example:
SELECT * FROM ownerships WHERE rolname = 'joel' LIMIT 5;
regclass | obj_desc | rolname
--+-
