Home • Explore • Blog • CI
☰



postgresql
27th chunk of `doc/src/sgml/ref/psql-ref.sgml`
780095d8d369a6b333b5caaee672c5fd031aeb6575a811110000000100000fae
 <quote>trigger</quote>, or <quote>window</quote>.
        To display only functions
        of specific type(s), add the corresponding letters <literal>a</literal>,
        <literal>n</literal>, <literal>p</literal>, <literal>t</literal>, or <literal>w</literal> to the command.
        If <replaceable
        class="parameter">pattern</replaceable> is specified, only
        functions whose names match the pattern are shown.
        Any additional arguments are type-name patterns, which are matched
        to the type names of the first, second, and so on arguments of the
        function.  (Matching functions can have more arguments than what
        you specify.  To prevent that, write a dash <literal>-</literal> as
        the last <replaceable class="parameter">arg_pattern</replaceable>.)
        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, additional information
        about each function is shown, including volatility,
        parallel safety, owner, security classification, whether it is
        leakproof, access privileges, language, internal name (for C and
        internal functions only), and description.
        Source code for a specific function can be seen
        using <literal>\sf</literal>.
        </para>

        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-df-uc">
        <term><literal>\dF[x+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
         Lists text search configurations.
         If <replaceable class="parameter">pattern</replaceable> is specified,
         only configurations 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, a full description of
         each configuration is shown, including the underlying text search
         parser and the dictionary list for each parser token type.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-dfd">
        <term><literal>\dFd[x+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
         Lists text search dictionaries.
         If <replaceable class="parameter">pattern</replaceable> is specified,
         only dictionaries 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, additional information
         is shown about each selected dictionary, including the underlying
         text search template and the option values.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-dfp">
        <term><literal>\dFp[x+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
         Lists text search parsers.
         If <replaceable class="parameter">pattern</replaceable> is specified,
         only parsers 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, a full description of
         each parser is shown, including the underlying functions and the
         list of recognized token types.
        </para>
        </listitem>
      </varlistentry>
Title: psql Meta-Commands: \df (continued), \dF, \dFd, \dFp
Summary
This section details more psql meta-commands for listing database objects: * `\df`: (Continued) Lists functions with options for filtering by type, name, and argument types. `S` modifier includes system objects, `x` displays expanded mode, and `+` shows additional function details like volatility, owner, and source code (via `\sf`). * `\dF`: Lists text search configurations, filtered by name. `x` displays expanded mode, `+` shows a full configuration description (parser and dictionary list). * `\dFd`: Lists text search dictionaries, filtered by name. `x` displays expanded mode, `+` shows additional dictionary information (template and option values). * `\dFp`: Lists text search parsers, filtered by name. `x` displays expanded mode, `+` shows a full parser description (functions and token types).