Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-sql-owner+M39337=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1e1tD3-0001RK-Lu
	for pgsql-sql@arkaria.postgresql.org; Tue, 10 Oct 2017 12:00:29 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-sql-owner+M39337=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1e1tD2-0007UR-Qa
	for pgsql-sql@arkaria.postgresql.org; Tue, 10 Oct 2017 12:00:28 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <depesz@depesz.com>)
	id 1e1tCz-0007S1-Vu
	for pgsql-sql@postgresql.org; Tue, 10 Oct 2017 12:00:26 +0000
Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com)
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <depesz@depesz.com>)
	id 1e1tCs-0001QR-Mi
	for pgsql-sql@postgresql.org; Tue, 10 Oct 2017 12:00:25 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com;
 s=20170201;
	h=In-Reply-To:Content-Type:MIME-Version:References:Reply-To:Message-ID:Subject:Cc:To:Sender:From:Date;
 bh=43ntTYXa/mDmWlahZBHc5ieW0vReOxB3Iln3X1t93x4=;
	b=KLlzhtrarpYUmzi/0AZ7OzG7vtFJ/+axzoSfAwrxddUsGVfVtJRh0FCgpK+E7lIS3UiXv6bZB4PBmJfCZZzKuGLPByPPQtU0YOrJ+Kx87eZfglIf9umZkyniZRdTdHgIItul8jvG1VUuWi1VPRzFzesKn6iIADXm6wzzE2fzv8g=;
Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com)
	by depesz.com with esmtpa (Exim 4.84_2)
	(envelope-from <depesz@depesz.com>)
	id 1e1tCq-0004g6-04; Tue, 10 Oct 2017 14:00:16 +0200
Date: Tue, 10 Oct 2017 14:00:15 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
To: ROS Didier <didier.ros@edf.fr>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Need Help on SQL Query
Message-ID: <20171010120015.GA17411@depesz.com>
Reply-To: depesz@depesz.com
References: <76762b7413164e9abff915ee223d2407@PCYINTPEXMU001.NEOPROD.EDF.FR>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <76762b7413164e9abff915ee223d2407@PCYINTPEXMU001.NEOPROD.EDF.FR>
User-Agent: Mutt/1.5.23 (2014-03-12)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On Tue, Oct 10, 2017 at 11:38:59AM +0000, ROS Didier wrote:
> Hi
>                I need to get the list of functions which are defined with "SECURITY-DEFINER" . How can I get this in SQL ?

select * from pg_proc where prosecdef;

Best regards,

depesz



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql