pgsql: Allow psql's \df and \do commands to specify argument types.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Allow psql's \df and \do commands to specify argument types.
Date: 2021-04-08 03:02:33
Message-ID: E1lUKwD-0004pn-3e@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow psql's \df and \do commands to specify argument types.

When dealing with overloaded function or operator names, having
to look through a long list of matches is tedious. Let's extend
these commands to allow specification of (input) argument types
to let such results be trimmed down. Each additional argument
is treated the same as the pattern argument of \dT and matched
against the appropriate argument's type name.

While at it, fix \dT (and these new options) to recognize the
usual notation of "foo[]" for "the array type over foo", and
to handle the special abbreviations allowed by the backend
grammar, such as "int" for "integer".

Greg Sabino Mullane, revised rather significantly by me

Discussion: https://postgr.es/m/CAKAnmmLF9Hhu02N+s7uAyLc5J1xZReg72HQUoiKhNiJV3_jACQ@mail.gmail.com

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 40 ++++++--
src/bin/psql/command.c | 48 +++++++++-
src/bin/psql/describe.c | 181 ++++++++++++++++++++++++++++++++++---
src/bin/psql/describe.h | 8 +-
src/bin/psql/help.c | 7 +-
src/fe_utils/string_utils.c | 6 ++
src/test/regress/expected/psql.out | 101 +++++++++++++++++++++
src/test/regress/sql/psql.sql | 13 +++
8 files changed, 374 insertions(+), 30 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2021-04-08 04:48:00 pgsql: Repair find_inheritance_children with no active snapshot
Previous Message Bruce Momjian 2021-04-08 02:30:41 pgsql: Add csvlog output for the new query_id value