change output of \dp - Mailing list pgsql-patches

From Euler Taveira de Oliveira
Subject change output of \dp
Date
Msg-id 20040310201014.2d47d080.euler@ufgnet.ufg.br
Whole thread Raw
Responses Re: change output of \dp  (Neil Conway <neilc@samurai.com>)
Re: change output of \dp  (Euler Taveira de Oliveira <euler@ufgnet.ufg.br>)
Re: change output of \dp  (Peter Eisentraut <peter_e@gmx.net>)
Re: change output of \dp  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Hi,

I just noticed that \dp outputs "Table" to indicate relations (tables, sequences and views) instead of "Relation" or
"Name".This patch just correct it, using "Name"  and attaching its "Type". 

Without the patch:

teste=# \d
         List of relations
 Schema |  Name  |   Type   | Owner
--------+--------+----------+-------
 public | ab     | sequence | euler
 public | foo    | table    | euler
 public | foobar | view     | euler
 public | teste  | table    | euler
(4 rows)

teste=# \dp
                  Access privileges for database "teste"
 Schema | Table  |              Access privileges
--------+--------+---------------------------------------------
 public | ab     | {euler=a*r*w*d*R*x*t*/euler,teste=ar/euler}
 public | foo    | {euler=a*r*w*d*R*x*t*/euler,teste=ar/euler}
 public | foobar |
 public | teste  | {euler=a*r*w*d*R*x*t*/euler,teste=ar/euler}
(4 rows)

And with the patch:

teste=# \dp
                  Access privileges for database "teste"
 Schema |  Name  |   Type   |              Access privileges
--------+--------+----------+---------------------------------------------
 public | ab     | sequence | {euler=a*r*w*d*R*x*t*/euler,teste=ar/euler}
 public | foo    | table    | {euler=a*r*w*d*R*x*t*/euler,teste=ar/euler}
 public | foobar | view     |
 public | teste  | table    | {euler=a*r*w*d*R*x*t*/euler,teste=ar/euler}
(4 rows)

Please apply it under HEAD, and if it's convenient, put it under 7_4 Branch.

Regards,

--
Euler Taveira de Oliveira
euler (at) ufgnet.ufg.br
Desenvolvedor Web e Administrador de Sistemas
UFGNet - Universidade Federal de Goiás

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Defining a "tinyint" data type - one byte unsigned
Next
From: Neil Conway
Date:
Subject: Re: change output of \dp