Home • Explore • Blog • CI
☰



postgresql
51th chunk of `doc/src/sgml/ref/psql-ref.sgml`
ccacc8de517692a164c95fe1c54b9d140f83448cbdfe93700000000100000fa3
 <envar>PSQL_PAGER</envar>
          or <envar>PAGER</envar> is set, output to be paged is piped to the
          specified program.  Otherwise a platform-dependent default program
          (such as <filename>more</filename>) is used.
          </para>

          <para>
          When using the <literal>\watch</literal> command to execute a query
          repeatedly, the environment variable <envar>PSQL_WATCH_PAGER</envar>
          is used to find the pager program instead, on Unix systems.  This is
          configured separately because it may confuse traditional pagers, but
          can be used to send output to tools that understand
          <application>psql</application>'s output format (such as
          <filename>pspg --stream</filename>).
          </para>
          </listitem>
          </varlistentry>

          <varlistentry id="app-psql-meta-command-pset-pager-min-lines">
          <term><literal>pager_min_lines</literal></term>
          <listitem>
          <para>
          If <literal>pager_min_lines</literal> is set to a number greater than the
          page height, the pager program will not be called unless there are
          at least this many lines of output to show. The default setting
          is 0.
          </para>
          </listitem>
          </varlistentry>

          <varlistentry id="app-psql-meta-command-pset-recordsep">
          <term><literal>recordsep</literal></term>
          <listitem>
          <para>
          Specifies the record (line) separator to use in unaligned
          output format. The default is a newline character.
          </para>
          </listitem>
          </varlistentry>

          <varlistentry id="app-psql-meta-command-pset-recordsep-zero">
          <term><literal>recordsep_zero</literal></term>
          <listitem>
          <para>
          Sets the record separator to use in unaligned output format to a zero
          byte.
          </para>
          </listitem>
          </varlistentry>

          <varlistentry id="app-psql-meta-command-pset-tableattr">
          <term><literal>tableattr</literal> (or <literal>T</literal>)</term>
          <listitem>
          <para>
          In <acronym>HTML</acronym> format, this specifies attributes
          to be placed inside the <sgmltag>table</sgmltag> tag.  This
          could for example be <literal>cellpadding</literal> or
          <literal>bgcolor</literal>. Note that you probably don't want
          to specify <literal>border</literal> here, as that is already
          taken care of by <literal>\pset border</literal>.
          If no
          <replaceable class="parameter">value</replaceable> is given,
          the table attributes are unset.
          </para>
          <para>
          In <literal>latex-longtable</literal> format, this controls
          the proportional width of each column containing a left-aligned
          data type.  It is specified as a whitespace-separated list of values,
          e.g., <literal>'0.2 0.2 0.6'</literal>.  Unspecified output columns
          use the last specified value.
          </para>
          </listitem>
          </varlistentry>

          <varlistentry id="app-psql-meta-command-pset-title">
          <term><literal>title</literal> (or <literal>C</literal>)</term>
          <listitem>
          <para>
          Sets the table title for any subsequently printed tables. This
          can be used to give your output descriptive tags. If no
          <replaceable class="parameter">value</replaceable> is given,
          the title is unset.
          </para>
          </listitem>
          </varlistentry>

          <varlistentry id="app-psql-meta-command-pset-tuples-only">
          <term><literal>tuples_only</literal> (or <literal>t</literal>)</term>
          <listitem>
          <para>
          If <replaceable class="parameter">value</replaceable> is specified
          it must be either <literal>on</literal> or <literal>off</literal>
          which
Title: psql Meta-Command \pset: Pager Minimum Lines, Record Separators, Table Attributes, Title, and Tuples Only Options
Summary
This section describes the remaining \pset options. It details the pager_min_lines option for setting the minimum number of output lines before the pager is invoked, the recordsep and recordsep_zero options for specifying record separators in unaligned output, the tableattr option for setting HTML table attributes or column widths in latex-longtable format, the title option for setting a table title, and the tuples_only option for showing rows without additional information.