Home • Explore • Blog • CI
☰



postgresql
22th chunk of `doc/src/sgml/ref/psql-ref.sgml`
87c637a3f9edb09404ba9f8a91ffceb05ff66713fbd18eed0000000100000faf
 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 support functions associated with operator families
        (see <xref linkend="xindex-support"/>).
        If <replaceable class="parameter">access-method-pattern</replaceable>
        is specified, only functions 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 functions 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, functions are
        displayed verbosely, with their actual parameter lists.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-db">
        <term><literal>\db[x+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>

        <listitem>
        <para>
        Lists tablespaces. If <replaceable
        class="parameter">pattern</replaceable>
        is specified, only tablespaces whose names match the pattern are shown.
        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 tablespace
        is listed with its associated options, on-disk size, permissions and
        description.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-dc-lc">
        <term><literal>\dc[Sx+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists conversions between character-set encodings.
        If <replaceable class="parameter">pattern</replaceable>
        is specified, only conversions whose names match the pattern are
        listed.
        By default, only user-created objects are shown;  supply a
        pattern or the <literal>S</literal> modifier to include system
        objects.
        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 object
        is listed with its associated description.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-dconfig">
        <term><literal>\dconfig[x+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists server configuration parameters and their values.
        If <replaceable class="parameter">pattern</replaceable> is specified,
        only parameters whose names match the pattern are listed.  Without
        a <replaceable class="parameter">pattern</replaceable>,
Title: psql Meta-Commands: \dAp, \db, \dc, \dconfig
Summary
This section describes the following psql meta-commands: * `\dAp`: Lists support functions associated with operator families, filtered by access method and operator family patterns. The `x` modifier displays results in expanded mode, and the `+` modifier displays functions with their actual parameter lists. * `\db`: Lists tablespaces, optionally filtered by a pattern. The `x` modifier displays results in expanded mode, and the `+` modifier includes associated options, on-disk size, permissions, and description. * `\dc`: Lists character-set encoding conversions, optionally filtered by a pattern. The `S` modifier includes system objects, the `x` modifier displays results in expanded mode, and the `+` modifier includes associated descriptions. * `\dconfig`: Lists server configuration parameters and their values, optionally filtered by a pattern. Without a pattern, lists all parameters.