Re: Only target lines of text - Mailing list pgsql-sql

On 11/14/2016 06:19 PM, Michael Moore wrote:
> 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';
>
> Thanks,
> Mike
>
>
substring with regexp captures.