Re: Psql patch to show access methods info - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Psql patch to show access methods info
Date
Msg-id 20181120134241.36tjfswliqimvncv@alvherre.pgsql
Whole thread Raw
In response to Re: Psql patch to show access methods info  (s.cherkashin@postgrespro.ru)
Responses Re: Psql patch to show access methods info  (Sergey Cherkashin <s.cherkashin@postgrespro.ru>)
List pgsql-hackers
On 2018-Nov-20, s.cherkashin@postgrespro.ru wrote:

> Ok, I fixed this.

Cool.  I'm not sure this is a good idea: "c.relname::pg_catalog.regclass"
I would use c.oid::pg_catalog.regclass instead.

But before getting into those details, I think we should discuss the
user interface that this patch is offering:

\dip [am pattern]
  lists index properties (according to doc patch)
  * OK, but why do we need an AM pattern?  ... reads regress output  ...
    oh, actually it's an index name pattern, not an AM pattern. Please fix docs.

\dicp [idx pattern] [column pattern]
  list index column properties
  * I think the column pattern part is pointless.

\dA{f,p,fo,fp,oc}
  Please explain what these are.

I think this is two patches -- one being the \dip/\dicp part, the other
the \dA additions.  Let's deal with them separately?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: pgbench - doCustom cleanup
Next
From: 066ce286@free.fr
Date:
Subject: Re: mysql_fdw crash