Re: psql missing feature: show permissions for functions - Mailing list pgsql-bugs

From John R Pierce
Subject Re: psql missing feature: show permissions for functions
Date
Msg-id 132201c49f5f$5444efd0$0200a8c0@hogranch.com
Whole thread Raw
In response to psql missing feature: show permissions for functions  (Jorge Godoy <godoy@ieee.org>)
Responses Re: psql missing feature: show permissions for functions
List pgsql-bugs
> I was trying to check some permissions on functions and then I noticed
> that there's no command in psql to show that information.  I've tried
> using "\z", "\df" and "\df+" without success on PostgreSQL 7.4.5.
>
> It would be an interesting addition to have that, as we do have the
> commands to show permissions on tables.

ah, I found it.  try...

    SELECT proacl FROM pg_proc WHERE proname='functioname';

pgsql-bugs by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Error starting service on Win2k
Next
From: Jorge Godoy
Date:
Subject: Re: psql missing feature: show permissions for functions