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.
pgsql-general by date
|Next:||From: Adrian Klaver||Date: 2011-07-28 13:37:07|
|Subject: Re: issue with pg_restore|
|Previous:||From: tommaso||Date: 2011-07-28 12:35:35|
|Subject: Re: postgres unable to start|