search any Text from the Stored Function

In this post, I am sharing a script to find any text or string in Stored Functions of PostgreSQL.
Many times we need to find any object name, column name or comment text in PostgreSQL Functions.

I prepared script using two views.

Using pg_proc:

select 
 proname AS FunctionName 
from pg_proc where prosrc like '%Your_Text%';

Using information_schema.routines:

select 
 routine_catalog AS DatabaseName
 ,routine_schema AS SchemaName
 ,routine_name AS FunctionName
 ,routine_type AS ObjectType
from information_schema.routines 
where routine_definition like '%Your_Text%'