dbcli / dbcli/pgcli

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

未关闭
#1,478 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
enhancement
主要语言
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

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。