roleauthority
bash-2.05b$ psql roleauthority
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
roleauthority=# select * from dba;
contaction | finace | log | pg_user | authority | userfuzzy | roleauthority | role
------------+--------+-----+---------+-----------+-----------+---------------+------
0 | 0 | 111 | 111 | 111 | 111 | 111 | 111
(1 row)
roleauthority=# select * from staff;
contaction | finace | log | pg_user | authority | userfuzzy | roleauthority | role
------------+--------+-----+---------+-----------+-----------+---------------+------
111 | 0 | 0 | 11 | 1 | 0 | 1 | 1
(1 row)
roleauthority=# select * from finace;
contaction | finace | log | pg_user | authority | userfuzzy | roleauthority | role
------------+--------+-----+---------+-----------+-----------+---------------+------
0 | 111 | 0 | 11 | 1 | 0 | 1 | 1
(1 row)
roleauthority=#
bash-2.05b$ psql authority
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
authority=# select * from zft;
contaction | finace | log | pg_user | authority | userfuzzy | role | roleauthority
------------+--------+-----+---------+-----------+-----------+------+---------------
111 | 111 | 0 | 11 | 1 | 0 | 1 | 1
(1 row)
authority=#