Only target lines of text

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Only target lines of text
Date: 2016-11-15 01:19:17
Message-ID: CACpWLjNu491rbpoyUPFbjV2yYx3QErmaBCnNNOCL1S=6jtYgSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2016-11-15 01:36:57 Re: Only target lines of text
Previous Message Amitabh Kant 2016-11-11 05:34:43 Re: Fwd: Regarding change in the size of database