Kevin Tu <kevintu888(at)gmail(dot)com> writes:
> This sounds easy enough, but I can't quite figure out searching around. Can
> anybody please tell me which catalog table to query to find out whether a
> role/user has execute permission on a function?
I'd suggest using has_function_privilege() instead of trying to duplicate
the logic for yourself.
https://www.postgresql.org/docs/current/functions-info.html
regards, tom lane