Re: Only target lines of text

Tom,
Yes, that's it, thanks!
And thanks Rob.
Mike

On Mon, Nov 14, 2016 at 5:57 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>