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

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...