This article is half-done without your Comment! *** Please share your thoughts via Comment ***
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:
|
1 2 3 |
select proname AS FunctionName from pg_proc where prosrc like '%Your_Text%'; |
Using information_schema.routines:
|
1 2 3 4 5 6 7 |
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%' |
Leave a Reply