Re: Only target lines of text

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Only target lines of text
Date: 2016-11-15 01:36:57
Message-ID: e3db3594-fa64-4f24-9b53-268dfa3cd60a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2016-11-15 01:57:40 Re: Only target lines of text
Previous Message Michael Moore 2016-11-15 01:19:17 Only target lines of text