Re: Bogus permissions display in 7.4

Basically our whole API of communicating ACL information to the user is
poor. Look at psql \z:

test=> create table test(x int);
CREATE TABLE
test=> grant all on test to public;
GRANT
test=> \z test
Access privileges for database "test"
Schema | Name | Type | Access privileges
--------+------+-------+------------------------------------------------------

public | test | table | {postgres=a*r*w*d*R*x*t*/postgres,=arwdRxt/postgres}
(1 row)

Do we actually expect folks to understand that? What use is \z really
then? Sure, maybe we document it in the GRANT manual page, but that
hardly makes it readable on its own.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073