Re: [COMMITTERS] pgsql-server: Have \dn+ show permissions and description

Christopher Kings-Lynne wrote:
> > With \dp having a schema column, how would we display permissions there?
> >
> > Access privileges for database "test"
> > Schema | Name | Type | Access privileges
> > --------+------+-------+-------------------
> > public | test | table |
> > (1 row)
> >
> > I don't think it makes sense to add schema to \dp if it would not
> > normally appear in the \dp display.
> >
> > I figured schema permissions were different enough from table that is
> > belonged under schema, no? Also, to me view/table/sequence are data
> > storage objects, while schemas seem different.
>
> Don't forget \db for tablespaces as well - that should work the same as
> \dn wrt permissions display.

OK, done and applied:

test=> \db
List of tablespaces
Name | Owner | Location
------------+----------+----------
pg_default | postgres |
pg_global | postgres |
temp | postgres | /bjm/tmp
(3 rows)

test=> \db+
List of tablespaces
Name | Owner | Location | Access privileges
------------+----------+----------+-----------------------------------
pg_default | postgres | |
pg_global | postgres | |

Tablespaces, being global, don't have comments so I didn't do that part.

--
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