On Thu, Feb 19, 2009 at 12:46:41PM -0500, Rob Richardson wrote:
> Can anyone suggest a query that will tell me the names of all functions
> (both trigger and normal) that contain a given string of text?
assuming you mean pl/* functions, you can simply use:
select proname from pg_proc where prosrc ~* 'string';
another solution might be to use pg_dump, and grep the dump, but select
from pg_proc does it's job.
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007