psql \dX: list extended statistics objects
Tomas Vondra <tomas.vondra@postgresql.org>
psql \dX: list extended statistics objects The new command lists extended statistics objects. All past releases with extended statistics are supported. This is a simplified version of commit 891a1d0bca, which had to be reverted due to not considering pg_statistic_ext_data is not accessible by regular users. Fields requiring access to this catalog were removed. It's possible to add them, but it'll require changes to core. Author: Tatsuro Yamada Reviewed-by: Julien Rouhaud, Alvaro Herrera, Tomas Vondra, Noriyoshi Shinoda Discussion: https://postgr.es/m/c027a541-5856-75a5-0868-341301e1624b%40nttcom.co.jp_1
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/psql-ref.sgml | modified | +21 −0 |
| src/bin/psql/command.c | modified | +3 −0 |
| src/bin/psql/describe.c | modified | +83 −0 |
| src/bin/psql/describe.h | modified | +3 −0 |
| src/bin/psql/help.c | modified | +1 −0 |
| src/bin/psql/tab-complete.c | modified | +3 −1 |
| src/test/regress/expected/stats_ext.out | modified | +116 −0 |
| src/test/regress/sql/stats_ext.sql | modified | +37 −0 |
Documentation touched
Discussion
- list of extended statistics on psql 82 messages · 2020-08-24 → 2021-07-27