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 toggles between the on and off settings. When expanded mode
is enabled, query results are displayed in two columns, with the
column name on the left and the data on the right. This mode is
useful if the data wouldn't fit on the screen in the
normal <quote>horizontal</quote> mode. In the auto setting, the
expanded mode is used whenever the query output has more than one
column and is wider than the screen; otherwise, the regular mode is
used. The auto setting is only
effective in the aligned and wrapped formats. In other formats, it
always behaves as if the expanded mode is off.
</para>
</listitem>
</varlistentry>
<varlistentry id="app-psql-meta-command-pset-fieldsep">
<term><literal>fieldsep</literal></term>
<listitem>
<para>
Specifies the field separator to be used in unaligned output
format. That way one can create, for example, tab-separated
output, which other programs might prefer. To
set a tab as field separator, type <literal>\pset fieldsep
'\t'</literal>. The default field separator is
<literal>'|'</literal> (a vertical bar).
</para>
</listitem>
</varlistentry>
<varlistentry id="app-psql-meta-command-pset-fieldsep-zero">
<term><literal>fieldsep_zero</literal></term>
<listitem>
<para>
Sets the field separator to use in unaligned output format to a zero
byte.
</para>
</listitem>
</varlistentry>
<varlistentry id="app-psql-meta-command-pset-footer">
<term><literal>footer</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 display of the table footer
(the <literal>(<replaceable>n</replaceable> rows)</literal> count).
If <replaceable class="parameter">value</replaceable> is omitted the
command toggles footer display on or off.
</para>
</listitem>
</varlistentry>
<varlistentry id="app-psql-meta-command-pset-format">
<term><literal>format</literal></term>
<listitem>
<para>
Sets the output format to one of <literal>aligned</literal>,
<literal>asciidoc</literal>,
<literal>csv</literal>,
<literal>html</literal>,
<literal>latex</literal>,
<literal>latex-longtable</literal>, <literal>troff-ms</literal>,
<literal>unaligned</literal>, or <literal>wrapped</literal>.
Unique abbreviations are allowed.
</para>
<para><literal>aligned</literal> format is the standard,
human-readable,