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

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

PostgreSQL Monitoring Tools

PostgreSQL pgBadger