Search text of all functions in PGAdmin

pgadmin, postgresql, sql

Solution

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?

Problem

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?

Original source

Related problems