pgsql: psql: Add support for \dpS and \zS.

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: psql: Add support for \dpS and \zS.
Date: 2023-01-07 11:11:07
Message-ID: E1pE76R-002TRd-G6@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

psql: Add support for \dpS and \zS.

This allows an optional "S" modifier to be added to \dp and \z, to
have them include system objects in the list.

Note that this also changes the behaviour of a bare \dp or \z without
the "S" modifier to include temp objects in the list, and exclude
information_schema objects, making them consistent with other psql
meta-commands.

Nathan Bossart, reviewed by Maxim Orlov.

Discussion: https://postgr.es/m/20221206193606.GB3078082@nathanxps13

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/ref/psql-ref.sgml | 12 ++++++++----
src/bin/psql/command.c | 23 +++++++++++++++--------
src/bin/psql/describe.c | 14 ++++++--------
src/bin/psql/describe.h | 2 +-
4 files changed, 30 insertions(+), 21 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tomas Vondra 2023-01-07 13:44:02 pgsql: Check relkind before using TABLESAMPLE in postgres_fdw
Previous Message David Rowley 2023-01-07 10:42:41 Re: pgsql: Fix calculation of which GENERATED columns need to be updated.