Thom Brown <thom(at)linux(dot)com> writes:
> So could we introduce either a command to show which objects are owned
> by a particular role, or allow a dry-run of DROP OWNED BY?
It's always been possible to do that:
begin;
drop owned by joe;
rollback;
I believe this is already the recommended approach if you're concerned
about what DROP CASCADE will do.
regards, tom lane