<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