Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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:
 proname AS FunctionName 
from pg_proc where prosrc like '%Your_Text%';

Using information_schema.routines:

 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%'


Popular posts from this blog

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

PostgreSQL Pgbadger Installation On Linux

Migrating From Oracle to PostgreSQL using ora2pg open source tools

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform