Home • Explore • Blog • CI
☰



postgresql
32th chunk of `doc/src/sgml/ref/psql-ref.sgml`
b83a5607c584ec610b4b82efcad6b53b6ed7d26db971b8900000000100000fa2
 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">
        <term><literal>\dRp[x+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists replication publications.
        If <replaceable class="parameter">pattern</replaceable> is
        specified, only those publications whose names match the pattern are
        listed.
        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 tables and
        schemas associated with each publication are shown as well.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-drs">
        <term><literal>\dRs[x+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists replication subscriptions.
        If <replaceable class="parameter">pattern</replaceable> is
        specified, only those subscriptions whose names match the pattern are
        listed.
        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, additional
        properties of the subscriptions are shown.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-dt">
        <term><literal>\dT[Sx+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists data types.
        If <replaceable class="parameter">pattern</replaceable> is
        specified, only types whose names match the pattern are listed.
        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, each type is
        listed with its internal name and size, its allowed values
        if it is an <type>enum</type> type, and its associated permissions.
        By default, only user-created objects are shown;  supply a
        pattern or the <literal>S</literal> modifier to include system
        objects.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-du">
        <term><literal>\du[Sx+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists database roles.
        (Since the concepts of <quote>users</quote> and <quote>groups</quote> have been
        unified into <quote>roles</quote>, this command is now equivalent to
        <literal>\dg</literal>.)
        By default, only user-created roles are shown; supply the
        <literal>S</literal> modifier to include system
Title: psql Meta-Commands: \dRp, \dRs, \dT, \du
Summary
This section details the psql meta-commands `\dRp`, `\dRs`, `\dT`, and `\du`: * `\dRp`: Lists replication publications, filtering by name pattern. `x` for expanded output, `+` to show associated tables and schemas. * `\dRs`: Lists replication subscriptions, filtering by name pattern. `x` for expanded output, `+` to show additional properties. * `\dT`: Lists data types, filtering by name pattern. `x` for expanded output, `+` to show internal details, allowed enum values, and permissions. `S` includes system objects. * `\du`: Lists database roles (equivalent to `\dg`). `S` includes system roles.