Thom Brown <thom@linux.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