Tuesday, 3 August 2021

Postgres: Query to search any text in all procedures

 ////////// Query


select * from (
select pg_get_functiondef(oid) as def
from pg_proc
where proname like 'fn_%') a where upper(def) ilike '%ENTITY_REGION_PROVINCE_MAPPING%' ;

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...