Re: psql missing feature: show permissions for functions

From: "John R Pierce" <pierce(at)hogranch(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>, "Jorge Godoy" <godoy(at)ieee(dot)org>
Subject: Re: psql missing feature: show permissions for functions
Date: 2004-09-20 22:15:25
Message-ID: 132201c49f5f$5444efd0$0200a8c0@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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';

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jorge Godoy 2004-09-20 22:35:58 Re: psql missing feature: show permissions for functions
Previous Message Conal Tuohy 2004-09-20 21:47:01 Re: Error starting service on Win2k