Re: [SQL] Need Help on SQL Query - Mailing list pgsql-sql

From hubert depesz lubaczewski
Subject Re: [SQL] Need Help on SQL Query
Date
Msg-id 20171010120015.GA17411@depesz.com
Whole thread Raw
In response to [SQL] Need Help on SQL Query  (ROS Didier <didier.ros@edf.fr>)
Responses Re: [SQL] Need Help on SQL Query  (ROS Didier <didier.ros@edf.fr>)
List pgsql-sql
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

pgsql-sql by date:

Previous
From: ROS Didier
Date:
Subject: [SQL] Need Help on SQL Query
Next
From: ROS Didier
Date:
Subject: Re: [SQL] Need Help on SQL Query