Dan Langille <dan(at)langille(dot)org> writes:
> Will I be able to give people the right to execute a function, but not
> view it?
Write it in C. Short of that, you're asking for unenforceable
restrictions on the ability to read pg_proc.
regards, tom lane