Jessica Richard <rjessil@yahoo.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
dropusers to see check the dependencies.
There's no need for a separate operation for that. Do
begin;
drop user foo;
rollback;
regards, tom lane