lcd1_dev=> select * from
lcd1_dev-> (select proname, unnest(string_to_array(prosrc, '\n')) as l from pg_proc) ss
lcd1_dev-> where l ~* 'ypoi_db';
proname | l
-----------------+---------------------------------------------------------------------------------------------------------------------
fgeteduprograms |
| -- ⌐ Copyright QuinStreet, Inc., 2016. All rights reserved.
| -- Author: Michael J. Moore
| -- Date: Nov. 1, 2016\r
| DECLARE \r
| --p_edu_subj_hiers text := 'MATHEMATICS,ENGLISH-LITERATURE,WEBDESIGN,POI_ONLY,BUSINESS,EDUCATION,FASHION,LEGAL';\r
| poi_db_values_table_cnt bigint := 0;\r
| p_dealer_keys_arr text := '{'||not_null(p_dealer_keys)||'}';\r
| p_service_keys_arr text := '{'||not_null(p_service_keys)||'}';\r
| p_edu_subj_hiers_arr text := '{'||not_null(p_edu_subj_hiers)||'}';\r