Re: Need Help on SQL Query

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: ROS Didier <didier(dot)ros(at)edf(dot)fr>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Need Help on SQL Query
Date: 2017-10-10 12:00:15
Message-ID: 20171010120015.GA17411@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message ROS Didier 2017-10-10 13:25:03 Re: Need Help on SQL Query
Previous Message ROS Didier 2017-10-10 11:38:59 Need Help on SQL Query