Re: Bogus permissions display in 7.4

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Basically our whole API of communicating ACL information to the user is
> poor. Look at psql \z:

Well, if you don't like that, there's always the spec's way:

regression=> select * from information_schema.table_privileges where table_name = 'mytable';
grantor | grantee | table_catalog | table_schema | table_name | privilege_type | is_grantable | with_hierarchy
---------+---------+---------------+--------------+------------+----------------+--------------+----------------
foo | foo | regression | public | mytable | SELECT | YES | NO
foo | foo | regression | public | mytable | DELETE | YES | NO
foo | foo | regression | public | mytable | INSERT | YES | NO
foo | foo | regression | public | mytable | UPDATE | YES | NO
foo | foo | regression | public | mytable | REFERENCES | YES | NO
foo | foo | regression | public | mytable | RULE | YES | NO
foo | foo | regression | public | mytable | TRIGGER | YES | NO
foo | bar | regression | public | mytable | SELECT | NO | NO
(8 rows)

I'm not sure this is really all that much more readable than

regression=> \z mytable
Access privileges for database "regression"
Schema | Name | Type | Access privileges
--------+---------+-------+------------------------------------
public | mytable | table | {foo=a*r*w*d*R*x*t*/foo,bar=r/foo}
(1 row)

but it's there if you want it.

regards, tom lane