Re: [BUGS] psql missing feature: show permissions for functions]

2004-09-20 Thread Bruce Momjian
Jorge Godoy wrote: > > Hi, > > > 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 tha

Re: [BUGS] psql missing feature: show permissions for functions

2004-09-20 Thread Alvaro Herrera
On Mon, Sep 20, 2004 at 07:35:58PM -0300, Jorge Godoy wrote: > testbase=# SELECT proacl, proargtypes FROM pg_proc WHERE proname='to_ascii'; > proacl | proargtypes > ---+- > {=X/postgres} | 25 > {=X/postgres} | 25 19 > {=X/postgres} | 25 23 >

Re: [BUGS] psql missing feature: show permissions for functions

2004-09-20 Thread Jorge Godoy
"John R Pierce" <[EMAIL PROTECTED]> writes: >> 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

Re: [BUGS] psql missing feature: show permissions for functions

2004-09-20 Thread John R Pierce
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 permiss

[BUGS] psql missing feature: show permissions for functions

2004-09-20 Thread Jorge Godoy
Hi, 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