dbcli / dbcli/pgcli

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

Open
#1,478 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Python
Stars
13.4k
Forks
612
Avg merge
6d 14h
Merged PRs (30d)
10

Description

## Description
In psql, when you run `\d+ `, 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.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.