EnterpriseDB - When querying a list of functions/procedures, how to distinguish between the two types

Question

I'm trying to query a list of Functions and Procedures in EnterpriseDB 9.2. I want to distinguish between the two types of function, however, as PgAdmin does in its tree display. I'm trying to script the creation of grant statements for new users, but I need to be able to distinguish between them, because one requires 'grant execute on function', while the other requires 'grant execute on procedure'.

So far, I've tried querying the list from pg_catalog.pg_proc and from information_schema.routines. Both of these list everything as a function.

Any ideas on how I can get to something that will help me identify each by it's right type?

Answer 1

Looks like I've found what I needed. There are views in the pg_catalog named pg_function and pg_procedure that make the distinction I need.