Home Explore Blog CI



postgresql

53th chunk of `doc/src/sgml/ref/psql-ref.sgml`
4578346af27fecc315b4cb7b094deb49e4353e8aa64586f20000000100000fa0
 value),
           <literal>column</literal>, <literal>page</literal>, or an
           <replaceable class="parameter">integer value</replaceable>.
          </para>

          <para>
           <literal>full</literal>: the expanded header is not truncated,
           and will be as wide as the widest output line.
          </para>

          <para>
           <literal>column</literal>: truncate the header line to the
           width of the first column.
          </para>

          <para>
           <literal>page</literal>: truncate the header line to the terminal
           width.
          </para>

          <para>
           <replaceable class="parameter">integer value</replaceable>: specify
           the exact maximum width of the header line.
          </para>
          </listitem>
          </varlistentry>
        </variablelist>
        </para>

        <para>
        Illustrations of how these different formats look can be seen in
        <xref linkend="app-psql-examples"/>, below.
        </para>

        <tip>
        <para>
        There are various shortcut commands for <command>\pset</command>. See
        <command>\a</command>, <command>\C</command>, <command>\f</command>,
        <command>\H</command>, <command>\t</command>, <command>\T</command>,
        and <command>\x</command>.
        </para>
        </tip>

        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-quit">
        <term><literal>\q</literal> or <literal>\quit</literal></term>
        <listitem>
        <para>
        Quits the <application>psql</application> program.
        In a script file, only execution of that script is terminated.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-qecho">
        <term><literal>\qecho <replaceable class="parameter">text</replaceable> [ ... ] </literal></term>
        <listitem>
        <para>
        This command is identical to <command>\echo</command> except
        that the output will be written to the query output channel, as
        set by <command>\o</command>.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-reset">
        <term><literal>\r</literal> or <literal>\reset</literal></term>
        <listitem>
        <para>
        Resets (clears) the query buffer.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-s">
        <term><literal>\s [ <replaceable class="parameter">filename</replaceable> ]</literal></term>
        <listitem>
        <para>
        Print <application>psql</application>'s command line history
        to <replaceable class="parameter">filename</replaceable>.
        If <replaceable class="parameter">filename</replaceable> is omitted,
        the history is written to the standard output (using the pager if
        appropriate).  This command is not available
        if <application>psql</application> was built
        without <application>Readline</application> support.
        </para>
        </listitem>
      </varlistentry>


      <varlistentry id="app-psql-meta-command-set">
        <term><literal>\set [ <replaceable class="parameter">name</replaceable> [ <replaceable class="parameter">value</replaceable> [ ... ] ] ]</literal></term>

        <listitem>
        <para>
        Sets the <application>psql</application> variable <replaceable
        class="parameter">name</replaceable> to <replaceable
        class="parameter">value</replaceable>, or if more than one value
        is given, to the concatenation of all of them. If only one
        argument is given, the variable is set to an empty-string value. To
        unset a variable, use the <command>\unset</command> command.
        </para>

        <para><command>\set</command> without any arguments displays the names and values
        of all currently-set <application>psql</application> variables.
        </para>

Title: psql Meta-Commands: \pset shortcuts, \q, \qecho, \reset, \s, \set
Summary
This section covers several psql meta-commands. It explains shortcuts for \pset, including \a, \C, \f, \H, \t, \T, and \x. It details \q (or \quit) for exiting psql, \qecho for writing output to the query output channel, \reset for clearing the query buffer, \s for printing command line history, and \set for setting psql variables.