Michael Moore <michaeljmoore(at)gmail(dot)com> writes:
> how can I change this so that it only shows me the lines of text containing
> the matching string?
> SELECT
> proname AS functionname,
> prosrc AS source
> FROM
> pg_proc
> WHERE
> prosrc ~* 'ypoi_db';
You mean you just want part of each prosrc entry? Try something like
select * from
(select proname, unnest(string_to_array(prosrc, '\n')) as l from pg_proc) ss
where l ~* 'ypoi_db';
regards, tom lane