From d913928c9c5e905d0062d1e7237b7fb5fbde61ed Mon Sep 17 00:00:00 2001 From: Dean Rasheed Date: Sat, 7 Jan 2023 11:09:26 +0000 Subject: 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 --- doc/src/sgml/ref/psql-ref.sgml | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 8a5285da9aa..3f994a35921 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1825,14 +1825,16 @@ INSERT INTO tbl1 VALUES ($1, $2) \bind 'first value' 'second value' \g - \dp [ pattern ] + \dp[S] [ pattern ] Lists tables, views and sequences with their associated access privileges. If pattern is specified, only tables, views and sequences whose names match the - pattern are listed. + pattern are listed. By default only user-created objects are shown; + supply a pattern or the S modifier to include + system objects. @@ -3575,14 +3577,16 @@ testdb=> \setenv LESS -imx4F - \z [ pattern ] + \z[S] [ pattern ] Lists tables, views and sequences with their associated access privileges. If a pattern is specified, only tables, views and sequences whose names match the - pattern are listed. + pattern are listed. By default only user-created objects are shown; + supply a pattern or the S modifier to include + system objects. -- cgit v1.2.3