Basically our whole API of communicating ACL information to the user is
poor. Look at psql \z:
test=> create table test(x int);CREATE TABLEtest=> grant all on test to public;GRANTtest=> \z test
Accessprivileges for database "test" Schema | Name | Type | Access
privileges--------+------+-------+------------------------------------------------------public | test | table |
{postgres=a*r*w*d*R*x*t*/postgres,=arwdRxt/postgres}(1row)
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@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073