Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c6ShC-0001TA-Bw for pgsql-sql@arkaria.postgresql.org; Tue, 15 Nov 2016 01:37:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c6ShA-0002ZV-NX for pgsql-sql@arkaria.postgresql.org; Tue, 15 Nov 2016 01:37:56 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c6SgC-0001VR-Iv for pgsql-sql@postgresql.org; Tue, 15 Nov 2016 01:36:56 +0000 Received: from mail-pg0-x231.google.com ([2607:f8b0:400e:c05::231]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1c6SgA-00058x-4w for pgsql-sql@postgresql.org; Tue, 15 Nov 2016 01:36:55 +0000 Received: by mail-pg0-x231.google.com with SMTP id 3so60414380pgd.0 for ; Mon, 14 Nov 2016 17:36:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding; bh=hH2ZT2jxSz3uEI3Onz7WZqCdfBgTep4JdqSYRLzKMZY=; b=MdaUYqOg9vggtBO6a+ax0a/VLJEui8ecgIA9gLMpysVwyJvPdS1puV32JRt1Bt67KH 0Un1q2DWmFTdHYcePGfd8ooSIV1IQIYdmJDxDalGtXzqjNdEJSn/Axh5M3oc78C+dk36 /QMrxx844zPans5PvCC5A02xaZYNR554Y2LPwlpM140MttZg9NRbR8HMwr02FEBAv8xF UxibmAGm/C5fs/K2BuFR250kzWTEC7Im6fdXahwqVXoAdHktMEOUQaj2Bxq66yd99R8m h8e7X09HnH5gg3TyfWPoZN/KKsijDuVVUsNDvGsjtNFTD09dSLHuphwmyVo21tOHaEUf VNUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=hH2ZT2jxSz3uEI3Onz7WZqCdfBgTep4JdqSYRLzKMZY=; b=X6l1MrXlfwWNptMibUmxKS7ZWCmlivfZ8ylALMq2eSFPfPzAnSJlRwqUYwGuYJE5xJ 9z1dCX8rTo8aUQf5+iV1wu13PoCfnZYPOZfml8+w6pBEluZcK7Yj1eiRJXS+NsdYdYF1 Psl9Mc57GLi3eFaoHgeWK7LyPmZ8Br0Jt6N+e6YbHfA3IpJpBVz0PwZ2hcaq+R9SzKEk HRpwVnfzkX5rO1W/ashkWqcu7pMzDgcoTX4NGw/rsjLx9rcV021C6AXKWDKLwqZgBqL7 lxxzCPtle/BUTfNTtJGTVPNswRy1JiT8yX5gXhFlgodjKDfxAmBEF5vTTTcFcGadwZiU oUrw== X-Gm-Message-State: ABUngvfOqZ4BIhpOOsK6JvB6L7pvveZf2gD+8JwaypptHT4deDQkUEUK8+F7WY3RJsDKVw== X-Received: by 10.98.22.196 with SMTP id 187mr41658340pfw.34.1479173812705; Mon, 14 Nov 2016 17:36:52 -0800 (PST) Received: from [155.100.214.120] ([155.100.214.120]) by smtp.gmail.com with ESMTPSA id z9sm37973514pfd.29.2016.11.14.17.36.51 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 14 Nov 2016 17:36:51 -0800 (PST) Subject: Re: Only target lines of text To: pgsql-sql@postgresql.org References: From: Rob Sargent Message-ID: Date: Mon, 14 Nov 2016 18:36:57 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org 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