\d+ metacommand doesn't indicate the name/type of what it's displaying
- 主要语言
- Python
- 星标
- 13.4k
- 派生
- 612
- 平均合并
- 6 天 14 小时
- 30 天内合并 PR
- 10
描述
## 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.
贡献指南
调研方向
先对表、视图和物化视图运行 \d+ 元命令,然后定位 pgcli 对该命令的实现和输出格式。将当前输出与 issue 中的 psql 示例进行比较;当输出能够识别所显示的对象是表、视图还是物化视图时,即表示完成。
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- postgresql, python
- 领域
- cli, databases
- Issue 类型
- 功能
- 难度
- 3/5
- 预计耗时
- 1-2 天
- 活跃度
- 停滞
- 描述清晰度
- 基本清楚
- 新手友好度
- 48/100