Since Postgres does not consider a table as a dependency of a function if
that table is referenced in the function (probably a good reason), I often
find myself in a position of asking "is this table/sequence/index
referenced in any of these N number of functions?"
Is there an easy way of essentially grep'ing all of the functions in a
given schema for a string?
Clearly if you had all of your functions in a nice VCS you could do this
but alas I don't yet live in that perfect world.
--
Wells Oliver
wellsoliver(at)gmail(dot)com