Re: Psql patch to show access methods info

Hi,

On 2019-07-15 22:03:31 +0300, Nikita Glukhov wrote:
> +      
> +        
> +          \dAc[+]
> +            [access-method-pattern
> +              [input-type-pattern]]
> +          
> +        
> +        
> +        
> +        Shows info index access method operator classes listed in
> +        .
> +        If access-method-patttern
> +        is specified, only operator classes associated with access method whose
> +        name matches pattern are shown.
> +        If input-type-pattern
> +        is specified, only procedures associated with families whose input type
> +        matches the pattern are shown.
> +        If + is appended to the command name, operator family
> +        and owner are listed.
> +        
> +        
> +      
> +
> +      
> +        
> +          \dAo[+]
> +            [access-method-pattern
> +              [operator-family-pattern]]
> +          
> +        
> +
> +        
> +        
> +        Lists operators () associated
> +        with access method operator families. If
> +        access-method-patttern is
> +        specified, only operators associated with access method whose name
> +        matches pattern are shown. If
> +        operator-family-pattern is
> +        specified, only operators associated with families whose name matches
> +        the pattern are shown.
> +        If + is appended to the command name, displays
> +        additional info.
> +        
> +        
> +      
> +
> +      
> +        
> +          \dAp[+]
> +            [access-method-pattern
> +              [operator-family-pattern]]
> +          
> +        
> +        
> +        
> +        Lists procedures () associated
> +        with access method operator families.
> +        If access-method-patttern
> +        is specified, only procedures associated with access method whose name
> +        matches pattern are shown.
> +        If operator-family-pattern
> +        is specified, only procedures associated with families whose name
> +        matches the pattern are shown.
> +        If + is appended to the command name, procedures
> +        listed with its names.
>          

Based on a quick skim of the thread - which means I most definitely
missed things - there's not been discussion of why we actually want to
add this.  Who's the prospective user of this facility? And why wouldn't
they just query pg_am[proc]?  None of this information seems like it's
going to be even remotely targeted towards even advanced users.  For
developers it's not clear what these add?

Adding stuff to psql isn't free. It adds clutter to psql's help output,
the commands need to be maintained (including cross-version code).

Greetings,

Andres Freund