Home • Explore • Blog • CI
☰



postgresql
29th chunk of `doc/src/sgml/ref/psql-ref.sgml`
57fd30051d1d8eb6c4bc7c6a702f4c2f117ed0f9456ac7ee0000000100000fa1
 an alias for <command>\lo_list</command>, which shows a
        list of large 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 large object is listed with its associated permissions,
        if any.
        </para>
        </listitem>
      </varlistentry>

      <varlistentry id="app-psql-meta-command-dl-uc">
        <term><literal>\dL[Sx+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists procedural languages. If <replaceable
        class="parameter">pattern</replaceable>
        is specified, only languages whose names match the pattern are listed.
        By default, only user-created languages
        are shown; supply 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
        language is listed with its call handler, validator, access privileges,
        and whether it is a system object.
        </para>
        </listitem>
      </varlistentry>


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

        <listitem>
        <para>
        Lists schemas (namespaces). If <replaceable
        class="parameter">pattern</replaceable>
        is specified, only schemas 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 permissions and description, if any.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-do-lc">
        <term><literal>\do[Sx+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> [ <replaceable class="parameter">arg_pattern</replaceable> [ <replaceable class="parameter">arg_pattern</replaceable> ] ] ]</literal></term>
        <listitem>
        <para>
        Lists operators with their operand and result types.
        If <replaceable class="parameter">pattern</replaceable> is
        specified, only operators whose names match the pattern are listed.
        If one <replaceable class="parameter">arg_pattern</replaceable> is
        specified, only prefix operators whose right argument's type name
        matches that pattern are listed.
        If two <replaceable class="parameter">arg_pattern</replaceable>s
        are specified, only binary operators whose argument type names match
        those patterns are listed.  (Alternatively, write <literal>-</literal>
        for the unused argument of a unary operator.)
        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 operator is shown, including
        the name of the underlying function, and whether it is leakproof.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-do-uc">
        <term><literal>\dO[Sx+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
Title: psql Meta-Commands: \dl, \dL, \dn, \do
Summary
This section details more psql meta-commands for listing database objects: * `\dl`: Alias for `\lo_list`, showing large objects. `x` displays expanded mode, `+` lists large objects with associated permissions. * `\dL`: Lists procedural languages, filtered by name. `S` includes system languages. `x` displays expanded mode, `+` lists the call handler, validator, access privileges and system object status. * `\dn`: Lists schemas (namespaces), filtered by name. `S` includes system objects. `x` displays expanded mode, `+` lists associated permissions and description. * `\do`: Lists operators with operand and result types, filtered by name and argument types. `S` includes system objects. `x` displays expanded mode, `+` shows underlying function name and leakproof status.