pgsql: psql \dX: list extended statistics objects

From: Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: psql \dX: list extended statistics objects
Date: 2021-01-20 21:58:05
Message-ID: E1l2LUL-0005VI-Um@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ad600bba0422dde4b73fbd61049ff2a3847b068a

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 21 ++++++
src/bin/psql/command.c | 3 +
src/bin/psql/describe.c | 83 +++++++++++++++++++++++
src/bin/psql/describe.h | 3 +
src/bin/psql/help.c | 1 +
src/bin/psql/tab-complete.c | 4 +-
src/test/regress/expected/stats_ext.out | 116 ++++++++++++++++++++++++++++++++
src/test/regress/sql/stats_ext.sql | 37 ++++++++++
8 files changed, 267 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tomas Vondra 2021-01-20 22:58:50 pgsql: Implement support for bulk inserts in postgres_fdw
Previous Message Tom Lane 2021-01-20 17:08:31 pgsql: Further tweaking of PG_SYSROOT heuristics for macOS.