Home • Explore • Blog • CI
☰



postgresql
21th chunk of `doc/src/sgml/ref/psql-ref.sgml`
70d93efce22b2485910db1b7a1fb47c4974019c0ae8a63fd0000000100000fa0
 class="parameter">access-method-pattern</replaceable></link>
              [<link linkend="app-psql-patterns"><replaceable class="parameter">input-type-pattern</replaceable></link>]]
          </literal>
        </term>
        <listitem>
        <para>
        Lists operator classes
        (see <xref linkend="xindex-opclass"/>).
        If <replaceable class="parameter">access-method-pattern</replaceable>
        is specified, only operator classes associated with access methods whose
        names match that pattern are listed.
        If <replaceable class="parameter">input-type-pattern</replaceable>
        is specified, only operator classes associated with input types whose
        names match that 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 operator
        class is listed with its associated operator family and owner.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-daf">
        <term>
          <literal>\dAf[x+]
            [<link linkend="app-psql-patterns"><replaceable class="parameter">access-method-pattern</replaceable></link>
              [<link linkend="app-psql-patterns"><replaceable class="parameter">input-type-pattern</replaceable></link>]]
          </literal>
        </term>
        <listitem>
        <para>
        Lists operator families
        (see <xref linkend="xindex-opfamily"/>).
        If <replaceable class="parameter">access-method-pattern</replaceable>
        is specified, only operator families associated with access methods whose
        names match that pattern are listed.
        If <replaceable class="parameter">input-type-pattern</replaceable>
        is specified, only operator families associated with input types whose
        names match that 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 operator
        family is listed with its owner.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-dao">
        <term>
          <literal>\dAo[x+]
            [<link linkend="app-psql-patterns"><replaceable class="parameter">access-method-pattern</replaceable></link>
              [<link linkend="app-psql-patterns"><replaceable class="parameter">operator-family-pattern</replaceable></link>]]
          </literal>
        </term>

        <listitem>
        <para>
        Lists operators associated with operator families
        (see <xref linkend="xindex-strategies"/>).
        If <replaceable class="parameter">access-method-pattern</replaceable>
        is specified, only members of operator families associated with access
        methods whose names match that pattern are listed.
        If <replaceable class="parameter">operator-family-pattern</replaceable>
        is specified, only members of operator families whose names match that
        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 operator
        is listed with its sort operator family (if it is an ordering operator),
        and whether its underlying function is leakproof.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-dap">
        <term>
          <literal>\dAp[x+]
            [<link linkend="app-psql-patterns"><replaceable class="parameter">access-method-pattern</replaceable></link>
              [<link linkend="app-psql-patterns"><replaceable class="parameter">operator-family-pattern</replaceable></link>]]
          </literal>
        </term>
        <listitem>
        <para>
        Lists
Title: psql Meta-Commands: \dAc, \dAf, \dAo, \dAp
Summary
This section describes the following psql meta-commands: * `\dAc`: Lists operator classes, filtered by access method and input type patterns. The `x` modifier displays results in expanded mode, and the `+` modifier includes the associated operator family and owner. * `\dAf`: Lists operator families, filtered by access method and input type patterns. The `x` modifier displays results in expanded mode, and the `+` modifier includes the owner. * `\dAo`: Lists operators associated with operator families, filtered by access method and operator family patterns. The `x` modifier displays results in expanded mode, and the `+` modifier includes the sort operator family and leakproof status. * `\dAp`: Lists...