On Thu, Jan 30, 2014 at 12:45 PM, Wells Oliver <wellsoli...@gmail.com>wrote:
> 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. > In this imperfect world, I usually just "pg_dump -s -n foo" to a file, then use grep, vi, etc. on that file. Cheers, Jeff