Home • Explore • Blog • CI
☰



postgresql
31th chunk of `doc/src/sgml/ref/psql-ref.sgml`
af30bcc60597f8f9bf824586614954c50d9a8a6fac5cd0160000000100000fb5
  <varlistentry id="app-psql-meta-command-dp-uc">
        <term><literal>\dP[itnx+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists partitioned relations.
        If <replaceable class="parameter">pattern</replaceable>
        is specified, only entries whose name matches the pattern are listed.
        The modifiers <literal>t</literal> (tables) and <literal>i</literal>
        (indexes) can be appended to the command, filtering the kind of
        relations to list.  By default, partitioned tables and indexes are
        listed.
        </para>

        <para>
        If the modifier <literal>n</literal> (<quote>nested</quote>) is used,
        or a pattern is specified, then non-root partitioned relations are
        included, and a column is shown displaying the parent of each
        partitioned relation.
        </para>

        <para>
        If <literal>x</literal> is appended to the command name, the results
        are displayed in expanded mode.
        If <literal>+</literal> is appended to the command name, the sum of the
        sizes of each relation's partitions is also displayed, along with the
        relation's description.
        If <literal>n</literal> is combined with <literal>+</literal>, two
        sizes are shown: one including the total size of directly-attached
        leaf partitions, and another showing the total size of all partitions,
        including indirectly attached sub-partitions.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-drds">
        <term><literal>\drds[x] [ <link linkend="app-psql-patterns"><replaceable class="parameter">role-pattern</replaceable></link> [ <link linkend="app-psql-patterns"><replaceable class="parameter">database-pattern</replaceable></link> ] ]</literal></term>
        <listitem>
        <para>
        Lists defined configuration settings.  These settings can be
        role-specific, database-specific, or both.
        <replaceable>role-pattern</replaceable> and
        <replaceable>database-pattern</replaceable> are used to select
        specific roles and databases to list, respectively.  If omitted, or if
        <literal>*</literal> is specified, all settings are listed, including those
        not role-specific or database-specific, respectively.
        If <literal>x</literal> is appended to the command name, the results
        are displayed in expanded mode.
        </para>

        <para>
        The <link linkend="sql-alterrole"><command>ALTER ROLE</command></link> and
        <link linkend="sql-alterdatabase"><command>ALTER DATABASE</command></link>
        commands are used to define per-role and per-database configuration
        settings.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-drg">
        <term><literal>\drg[Sx] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists information about each granted role membership, including
        assigned options (<literal>ADMIN</literal>,
        <literal>INHERIT</literal> and/or <literal>SET</literal>) and grantor.
        See the <link linkend="sql-grant"><command>GRANT</command></link>
        command for information about role memberships.
        </para>
        <para>
        By default, only grants to user-created roles are shown; supply the
        <literal>S</literal> modifier to include system roles.
        If <replaceable class="parameter">pattern</replaceable> is specified,
        only grants to those roles whose names match the pattern are listed.
        If <literal>x</literal> is appended to the command name, the results
        are displayed in expanded mode.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-drp">
Title: psql Meta-Commands: \dP, \drds, \drg
Summary
This section describes the psql meta-commands `\dP`, `\drds`, and `\drg`: * `\dP`: Lists partitioned relations. Includes options for filtering by table or index type (`t`, `i`), showing nested partitions (`n`), expanded output (`x`), and displaying partition sizes and descriptions (`+`). The `n` and `+` options can be combined to show sizes for directly-attached and all partitions. * `\drds`: Lists role-specific and database-specific configuration settings, allowing filtering by role and database patterns. `x` provides expanded output. * `\drg`: Lists granted role memberships, including options and grantor. `S` includes system roles. The listing can be filtered by role name. `x` provides expanded output.