[ <replaceable class="parameter">value</replaceable> ] ]</literal></term>
<listitem>
<para>
This command sets options affecting the output of query result tables.
<replaceable class="parameter">option</replaceable>
indicates which option is to be set. The semantics of
<replaceable class="parameter">value</replaceable> vary depending
on the selected option. For some options, omitting <replaceable
class="parameter">value</replaceable> causes the option to be toggled
or unset, as described under the particular option. If no such
behavior is mentioned, then omitting
<replaceable class="parameter">value</replaceable> just results in
the current setting being displayed.
</para>
<para>
<command>\pset</command> without any arguments displays the current status
of all printing options.
</para>
<para>
Adjustable printing options are:
<variablelist>
<varlistentry id="app-psql-meta-command-pset-border">
<term><literal>border</literal></term>
<listitem>
<para>
The <replaceable class="parameter">value</replaceable> must be a
number. In general, the higher
the number the more borders and lines the tables will have,
but details depend on the particular format.
In <acronym>HTML</acronym> format, this will translate directly
into the <literal>border=...</literal> attribute.
In most other formats only values 0 (no border), 1 (internal
dividing lines), and 2 (table frame) make sense, and values above 2
will be treated the same as <literal>border = 2</literal>.
The <literal>latex</literal> and <literal>latex-longtable</literal>
formats additionally allow a value of 3 to add dividing lines
between data rows.
</para>
</listitem>
</varlistentry>
<varlistentry id="app-psql-meta-command-pset-columns">
<term><literal>columns</literal></term>
<listitem>
<para>
Sets the target width for the <literal>wrapped</literal> format, and also
the width limit for determining whether output is wide enough to
require the pager or switch to the vertical display in expanded auto
mode.
Zero (the default) causes the target width to be controlled by the
environment variable <envar>COLUMNS</envar>, or the detected screen width
if <envar>COLUMNS</envar> is not set.
In addition, if <literal>columns</literal> is zero then the
<literal>wrapped</literal> format only affects screen output.
If <literal>columns</literal> is nonzero then file and pipe output is
wrapped to that width as well.
</para>
</listitem>
</varlistentry>
<varlistentry id="app-psql-meta-command-pset-csv-fieldsep">
<term><literal>csv_fieldsep</literal></term>
<listitem>
<para>
Specifies the field separator to be used in
<acronym>CSV</acronym> output format. If the separator character
appears in a field's value, that field is output within double
quotes, following standard <acronym>CSV</acronym> rules.
The default is a comma.
</para>
</listitem>
</varlistentry>
<varlistentry id="app-psql-meta-command-pset-expanded">
<term><literal>expanded</literal> (or <literal>x</literal>)</term>
<listitem>
<para>
If <replaceable class="parameter">value</replaceable> is specified it
must be either <literal>on</literal> or <literal>off</literal>, which
will enable or disable expanded mode, or <literal>auto</literal>.
If <replaceable class="parameter">value</replaceable> is omitted the
command