Horton

Re: Psql patch to show access methods info

Alexander Korotkov <a.korotkov@postgrespro.ru>

View thread View on postgr.es
From: Alexander Korotkov <a.korotkov@postgrespro.ru>
To: Nikita Glukhov <n.gluhov@postgrespro.ru>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Thomas Munro <thomas.munro@gmail.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, David Steele <david@pgmasters.net>, Michael Paquier <michael@paquier.xyz>
Date: 2019-07-22T22:57:29Z
Lists: pgsql-hackers 
On Mon, Jul 22, 2019 at 11:25 PM Nikita Glukhov <n.gluhov@postgrespro.ru> wrote:
> Columns "Handler" and "Description" were added to \dA+.
>
> \dA [NAME] now shows only amname and amtype.

Cool!

> Also added support for pre-9.6 server versions to both \dA and \dA+.

I was going to ask about that.  You got ahead of me :-)

In general, patchset is very cool.  It was always scary there is no
way in psql to see am/opclass/opfamily information rather than query
catalog directly.  Shape of patches also looks good.

I'm going to push it.  Probably, someone find that commands syntax and
output formats are not well discussed yet.  But we're pretty earlier
in 13 release cycle.  So, we will have time to work out a criticism if
any.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Commits

  1. Show opclass and opfamily related information in psql