Home • Explore • Blog • CI
☰



postgresql
23th chunk of `doc/src/sgml/ref/psql-ref.sgml`
a31db9b7ff97c9392188855513e7103cd58cca14dfc122790000000100000fa5
 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>, only
        parameters that are set to non-default values are listed.
        (Use <literal>\dconfig *</literal> to see all parameters.)
        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
        parameter is listed with its data type, context in which the
        parameter can be set, and access privileges (if non-default access
        privileges have been granted).
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-dc-uc">
        <term><literal>\dC[x+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Lists type casts.
        If <replaceable class="parameter">pattern</replaceable>
        is specified, only casts whose source or target types 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
        information about each cast is shown, including whether its underlying
        function is leakproof, and the cast's description.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-dd-lc">
        <term><literal>\dd[Sx] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
        <listitem>
        <para>
        Shows the descriptions of objects of type <literal>constraint</literal>,
        <literal>operator class</literal>, <literal>operator family</literal>,
        <literal>rule</literal>, and <literal>trigger</literal>. All
        other comments may be viewed by the respective backslash commands for
        those object types.
        </para>

        <para><literal>\dd</literal> displays descriptions for objects matching the
        <replaceable class="parameter">pattern</replaceable>, or of visible
        objects of the appropriate type if no argument is given.  But in either
        case, only objects that have a description 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.
        </para>

        <para>
        Descriptions for objects can be created with the <link
        linkend="sql-comment"><command>COMMENT</command></link>
        <acronym>SQL</acronym> command.
       </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-dd-uc">
        <term><literal>\dD[Sx+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>
Title: psql Meta-Commands: \dconfig, \dC, \dd, \dD
Summary
This section details the following psql meta-commands: * `\dconfig`: Lists server configuration parameters and their values, filtered by a pattern. Without a pattern, it shows non-default parameters. `x` displays expanded mode, `+` includes data type, context, and access privileges. * `\dC`: Lists type casts, filtered by source or target types. `x` displays expanded mode, `+` includes leakproof status and description. * `\dd`: Shows descriptions for constraints, operator classes/families, rules, and triggers. Filters by pattern or shows visible objects with descriptions. `S` includes system objects, `x` displays expanded mode. * `\dD`: