Jessica Richard <rjessil(at)yahoo(dot)com> writes:
> I am sure in the future there will be times that I need to check the ownership of the functions but not allowed to drop users to see check the dependencies.
There's no need for a separate operation for that. Do
begin;
drop user foo;
rollback;
regards, tom lane