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.
Description
In psql, when you run
\d+ <name>
, the first line of output will look like thisThis 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.