Re: Grep'ing for a string in all functions in a schema?

Wells Oliver wrote on 30.01.2014 21:45:
> 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.

As I occasionally come across this myself, I have built such a feature into SQL Workbench/J

http://sql-workbench.net/manual/wb-commands.html#command-search-source
http://sql-workbench.net/wbgrepsource_png.html

or through the UI
http://sql-workbench.net/objectsearcher_png.html

it offers a bit more flexibility than just a LIKE on the source code

(but that is of course not available if you are using psql or pgAdmin)

Thomas