Search text of all functions in PGAdmin

Question

Using PostgreSQL with pgAdmin, and was wondering if there is a way to search ALL of the functions of a database for a particular text.

Is this possible?

Answer 1

Something like this should work:

select proname, prosrc from pg_proc where prosrc like '%search text%';

see How to display the function, procedure, triggers source code in postgresql?