Re: Psql patch to show access methods info

David Steele <david@pgmasters.net>

From: David Steele <david@pgmasters.net>
To: Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, Michael Paquier <michael@paquier.xyz>, Andres Freund <andres@anarazel.de>, Nikita Glukhov <n.gluhov@postgrespro.ru>, Thomas Munro <thomas.munro@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Date: 2020-03-02T13:33:04Z
Lists: pgsql-hackers
Hi Alexander,

On 1/21/20 5:37 PM, Alvaro Herrera wrote:
> On 2020-Jan-21, Alvaro Herrera wrote:
> 
>> c) it would be damn handy if \dAf (maybe \dAf+) lists the datatypes that
>>     each opfamily has opclasses for.  Maybe make the output an array, like
>>     {int4,int8,numeric,...}  Something like [*] but somehow make it
>>     prettier?
> 
> Sorry, I forgot to copy-edit my text here: I said "make it prettier",
> but the query I submitted is already pretty enough ISTM; I had written
> that comment when I only had the array_agg() version, but then I changed
> it to string_agg() and that seems to have mostly done the trick.  Maybe
> improve the format_type() bit to omit the quotes, if possible, but that
> doesn't seem a big deal.

The last CF for PG13 has now started.  Do you know when you'll be able 
to supply a new patch to address Álvaro's review?

Regards,
-- 
-David
david@pgmasters.net



Commits

  1. Show opclass and opfamily related information in psql