Re: List Functions and Code

On Thursday, July 28, 2011 6:31:32 am Rebecca Clarke wrote:
> Hi
>
> I want to search and list all the functions in a database that reference a
> particular table within its code. Is there a way to do this?
>
> I can list all the functions from pg_proc, however there is nothing there
> which provides the code of the function, so therefore I can't query if it
> mentions a table. I've tried looking in information_schema.routines but
> this unfortunately does not have it either.
>
> Rebecca

http://www.postgresql.org/docs/9.0/interactive/catalog-pg-proc.html

prosrc in pg_proc should, with the following caveat from the docs:

"For compiled functions, both built-in and dynamically loaded, prosrc contains
the function's C-language name (link symbol). For all other currently-known
language types, prosrc contains the function's source text. probin is unused
except for dynamically-loaded C functions, for which it gives the name of the
shared library file containing the function. "

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com