> 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
pgsql-bugs by date
|Next:||From: Jorge Godoy||Date: 2004-09-20 22:35:58|
|Subject: Re: psql missing feature: show permissions for functions|
|Previous:||From: Conal Tuohy||Date: 2004-09-20 21:47:01|
|Subject: Re: Error starting service on Win2k|