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

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Grep'ing for a string in all functions in a schema?
Дата
Msg-id CAOC+FBVQFOn58ajNHDLMwaZ3vEJ=HcG0Hv2h178xjmQr8DCdCA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Grep'ing for a string in all functions in a schema?  (bricklen <bricklen@gmail.com>)
Re: Grep'ing for a string in all functions in a schema?  (Jeff Janes <jeff.janes@gmail.com>)
Re: Grep'ing for a string in all functions in a schema?  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
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@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Ovid
Дата:
Сообщение: Re: permission denied for relation
Следующее
От: bricklen
Дата:
Сообщение: Re: Grep'ing for a string in all functions in a schema?