\d+ metacommand doesn't indicate the name/type of what it's displaying

[NasaGeek]

Description

In psql, when you run \d+ <name>, the first line of output will look like this

                                   Materialized view "public.matviewname"
                                                  View "public.viewname"
                                                                   Table "public.tablename"

This is useful information for exploration. While you can typically infer whether something is a table or view simply by checking if there's a view definition included in the output, I could find no way to distinguish between a View and a Materialized View in pgcli's current output.

Your environment

I don't think that the environment is all that relevant, as this is not really a bug, just a feature opportunity. It couldn't hurt, though:

• Ubuntu 22.04
• pgcli 4.1.0
• I have it installed through nix, getting the full list of dependency versions is outside of my wheelhouse.

• [x] Please provide your OS and version information.
• [x] Please provide your CLI version.
• [ ] What is the output of pip freeze command.