pgsql: Show opclass and opfamily related information in psql

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Show opclass and opfamily related information in psql
Date: 2020-03-08 10:35:29
Message-ID: E1jAtHN-0006Pk-1V@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Show opclass and opfamily related information in psql

This commit provides psql commands for listing operator classes, operator
families and its contents in psql. New commands will be useful for exploring
capabilities of both builtin opclasses/opfamilies as well as
opclasses/opfamilies defined in extensions.

Discussion: https://postgr.es/m/1529675324.14193.5.camel%40postgrespro.ru
Author: Sergey Cherkashin, Nikita Glukhov, Alexander Korotkov
Reviewed-by: Michael Paquier, Alvaro Herrera, Arthur Zakirov
Reviewed-by: Kyotaro Horiguchi, Andres Freund

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 91 ++++++++++
src/bin/psql/command.c | 33 +++-
src/bin/psql/describe.c | 335 +++++++++++++++++++++++++++++++++++++
src/bin/psql/describe.h | 19 +++
src/bin/psql/help.c | 4 +
src/bin/psql/tab-complete.c | 16 +-
src/test/regress/expected/psql.out | 162 ++++++++++++++++++
src/test/regress/sql/psql.sql | 18 ++
8 files changed, 676 insertions(+), 2 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2020-03-08 19:09:19 pgsql: Add an explicit test to catch changes in checksumming calculatio
Previous Message Peter Geoghegan 2020-03-08 00:45:22 pgsql: pageinspect: Fix types used for bt_metap() columns.

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2020-03-08 10:47:31 Re: Psql patch to show access methods info
Previous Message Fabien COELHO 2020-03-08 08:02:19 Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)