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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
