agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rob Sargent <robjsargent@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Only target lines of text
Date: Mon, 14 Nov 2016 18:36:57 -0700
Message-ID: <e3db3594-fa64-4f24-9b53-268dfa3cd60a@gmail.com> (raw)
In-Reply-To: <CACpWLjNu491rbpoyUPFbjV2yYx3QErmaBCnNNOCL1S=6jtYgSw@mail.gmail.com>
References: <CACpWLjNu491rbpoyUPFbjV2yYx3QErmaBCnNNOCL1S=6jtYgSw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (7+ messages) latest in thread
Message-ID: <e3db3594-fa64-4f24-9b53-268dfa3cd60a@gmail.com>
Permalink: ../e3db3594-fa64-4f24-9b53-268dfa3cd60a@gmail.com/
Also on: postgresql.org/message-id/e3db3594-fa64-4f24-9b53-268dfa3cd60a@gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com
Subject: Re: Only target lines of text
In-Reply-To: <e3db3594-fa64-4f24-9b53-268dfa3cd60a@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox