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