Re: Grep'ing for a string in all functions in a schema? - Mailing list pgsql-general

From Jeff Janes
Subject Re: Grep'ing for a string in all functions in a schema?
Date
Msg-id CAMkU=1zUHaSobkGUE_25WLK-hoB-crGN2cmH2xnckrTO=kF7aw@mail.gmail.com
Whole thread Raw
In response to Grep'ing for a string in all functions in a schema?  (Wells Oliver <wellsoliver@gmail.com>)
List pgsql-general
On Thu, Jan 30, 2014 at 12:45 PM, Wells Oliver <wellsoliver@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

pgsql-general by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Grep'ing for a string in all functions in a schema?
Next
From: Tim Uckun
Date:
Subject: Database snapshots or clones for staging and testing.