{"Entry":{"collection":"psql","key":"cmd-70-73-65-74","name":"\\pset","aliases":["\\pset"],"metadata":{"aliases":["\\pset"],"category":"Output and formatting","content_hash":"a9be6e5fc779d4cb716d15b40c3bed7a68c91331b5dc7be9d444d18ace8024a3","imported_at":"2026-09-30T00:40:45.138819+08:00","name":"\\pset","name_zh":"","slug":"cmd-70-73-65-74","summary":"This command sets options affecting the output of query result tables. option indicates which option is to be set. The semantics of value vary depending on the selected option. For some options, omitting value causes the option to be toggled or unset, as described under the particular option. If no such behavior is mentioned, then omitting value just results in the current setting being displayed."}},"Definition":{"Collection":"psql","Key":"cmd-70-73-65-74","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-70-73-65-74","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","Facts":{"command":"\\pset","comparison_data":{"definition":"This command sets options affecting the output of query result tables. option indicates which option is to be set. The semantics of value vary depending on the selected option. For some options, omitting value causes the option to be toggled or unset, as described under the particular option. If no such behavior is mentioned, then omitting value just results in the current setting being displayed. \\pset without any arguments displays the current status of all printing options. Adjustable printing options are: border The value 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 HTML format, this will translate directly into the border=... 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 border = 2 . The latex and latex-longtable formats additionally allow a value of 3 to add dividing lines between data rows. columns Sets the target width for the wrapped 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 COLUMNS , or the detected screen width if COLUMNS is not set. In addition, if columns is zero then the wrapped format only affects screen output. If columns is nonzero then file and pipe output is wrapped to that width as well. csv_fieldsep Specifies the field separator to be used in CSV output format. If the separator character appears in a field's value, that field is output within double quotes, following standard CSV rules. The default is a comma. expanded (or x ) If value is specified it must be either on or off , which will enable or disable expanded mode, or auto . If value 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 “ horizontal ” 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. fieldsep 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 \\pset fieldsep '\\t' . The default field separator is '|' (a vertical bar). fieldsep_zero Sets the field separator to use in unaligned output format to a zero byte. footer If value is specified it must be either on or off which will enable or disable display of the table footer (the ( n rows) count). If value is omitted the command toggles footer display on or off. format Sets the output format to one of aligned , asciidoc , csv , html , latex , latex-longtable , troff-ms , unaligned , or wrapped . Unique abbreviations are allowed. aligned format is the standard, human-readable, nicely formatted text output; this is the default. unaligned format writes all columns of a row on one line, separated by the currently active field separator. This is useful for creating output that might be intended to be read in by other programs, for example, tab-separated or comma-separated format. However, the field separator character is not treated specially if it appears in a column's value; so CSV format may be better suited for such purposes. csv format writes column values separated by commas, applying the quoting rules described in RFC 4180 . This output is compatible with the CSV format of the server's COPY command. A header line with column names is generated unless the tuples_only parameter is on . Titles and footers are not printed. Each row is terminated by the system-dependent end-of-line character, which is typically a single newline ( \\n ) for Unix-like systems or a carriage return and newline sequence ( \\r\\n ) for Microsoft Windows. Field separator characters other than comma can be selected with \\pset csv_fieldsep . wrapped format is like aligned but wraps wide data values across lines to make the output fit in the target column width. The target width is determined as described under the columns option. Note that psql will not attempt to wrap column header titles; therefore, wrapped format behaves the same as aligned if the total width needed for column headers exceeds the target. The asciidoc , html , latex , latex-longtable , and troff-ms formats put out tables that are intended to be included in documents using the respective mark-up language. They are not complete documents! This might not be necessary in HTML , but in LaTeX you must have a complete document wrapper. The latex format uses LaTeX 's tabular environment. The latex-longtable format requires the LaTeX longtable and booktabs packages. linestyle Sets the border line drawing style to one of ascii , old-ascii , or unicode . Unique abbreviations are allowed. (That would mean one letter is enough.) The default setting is ascii . This option only affects the aligned and wrapped output formats. ascii style uses plain ASCII characters. Newlines in data are shown using a + symbol in the right-hand margin. When the wrapped format wraps data from one line to the next without a newline character, a dot ( . ) is shown in the right-hand margin of the first line, and again in the left-hand margin of the following line. old-ascii style uses plain ASCII characters, using the formatting style used in PostgreSQL 8.4 and earlier. Newlines in data are shown using a : symbol in place of the left-hand column separator. When the data is wrapped from one line to the next without a newline character, a ; symbol is used in place of the left-hand column separator. unicode style uses Unicode box-drawing characters. Newlines in data are shown using a carriage return symbol in the right-hand margin. When the data is wrapped from one line to the next without a newline character, an ellipsis symbol is shown in the right-hand margin of the first line, and again in the left-hand margin of the following line. When the border setting is greater than zero, the linestyle option also determines the characters with which the border lines are drawn. Plain ASCII characters work everywhere, but Unicode characters look nicer on displays that recognize them. null Sets the string to be printed in place of a null value. The default is to print nothing, which can easily be mistaken for an empty string. For example, one might prefer \\pset null '(null)' . numericlocale If value is specified it must be either on or off which will enable or disable display of a locale-specific character to separate groups of digits to the left of the decimal marker. If value is omitted the command toggles between regular and locale-specific numeric output. pager Controls use of a pager program for query and psql help output. When the pager option is off , the pager program is not used. When the pager option is on , the pager is used when appropriate, i.e., when the output is to a terminal and will not fit on the screen. The pager option can also be set to always , which causes the pager to be used for all terminal output regardless of whether it fits on the screen. \\pset pager without a value toggles pager use on and off. If the environment variable PSQL_PAGER or PAGER is set, output to be paged is piped to the specified program. Otherwise a platform-dependent default program (such as more ) is used. When using the \\watch command to execute a query repeatedly, the environment variable PSQL_WATCH_PAGER 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 psql 's output format (such as pspg --stream ). pager_min_lines If pager_min_lines 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. recordsep Specifies the record (line) separator to use in unaligned output format. The default is a newline character. recordsep_zero Sets the record separator to use in unaligned output format to a zero byte. tableattr (or T ) In HTML format, this specifies attributes to be placed inside the table tag. This could for example be cellpadding or bgcolor . Note that you probably don't want to specify border here, as that is already taken care of by \\pset border . If no value is given, the table attributes are unset. In latex-longtable 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., '0.2 0.2 0.6' . Unspecified output columns use the last specified value. title (or C ) Sets the table title for any subsequently printed tables. This can be used to give your output descriptive tags. If no value is given, the title is unset. tuples_only (or t ) If value is specified it must be either on or off which will enable or disable tuples-only mode. If value is omitted the command toggles between regular and tuples-only output. Regular output includes extra information such as column headers, titles, and various footers. In tuples-only mode, only actual table data is shown. unicode_border_linestyle Sets the border drawing style for the unicode line style to one of single or double . unicode_column_linestyle Sets the column drawing style for the unicode line style to one of single or double . unicode_header_linestyle Sets the header drawing style for the unicode line style to one of single or double . xheader_width Sets the maximum width of the header for expanded output to one of full (the default value), column , page , or an integer value . full : the expanded header is not truncated, and will be as wide as the widest output line. column : truncate the header line to the width of the first column. page : truncate the header line to the terminal width. integer value : specify the exact maximum width of the header line. Illustrations of how these different formats look can be seen in Examples , below. Tip There are various shortcut commands for \\pset . See \\a , \\C , \\f , \\H , \\t , \\T , and \\x .","modifiers":[],"signature":"\\pset [ option [ value ] ]","spellings":["\\pset"]},"comparison_hash":"2cf4022d6b3009357fbbb57d5f824e834137950e9c9798e71c29e50f0956c47c","description":["This command sets options affecting the output of query result tables. option indicates which option is to be set. The semantics of value vary depending on the selected option. For some options, omitting value causes the option to be toggled or unset, as described under the particular option. If no such behavior is mentioned, then omitting value just results in the current setting being displayed."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\pset"}],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-PSET\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\pset [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eThis command sets options affecting the output of query result tables. \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e indicates which option is to be set. The semantics of \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e vary depending on the selected option. For some options, omitting \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e causes the option to be toggled or unset, as described under the particular option. If no such behavior is mentioned, then omitting \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e just results in the current setting being displayed.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"command\"\u003e\\pset\u003c/code\u003e without any arguments displays the current status of all printing options.\u003c/p\u003e\n\u003cp\u003eAdjustable printing options are:\u003c/p\u003e\n\u003cdiv class=\"variablelist\"\u003e\n\u003cdl class=\"variablelist\"\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-BORDER\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eborder\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e 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 HTML format, this will translate directly into the \u003ccode class=\"literal\"\u003eborder=...\u003c/code\u003e 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 \u003ccode class=\"literal\"\u003eborder = 2\u003c/code\u003e. The \u003ccode class=\"literal\"\u003elatex\u003c/code\u003e and \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e formats additionally allow a value of 3 to add dividing lines between data rows.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-COLUMNS\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003ecolumns\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the target width for the \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e 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 \u003ccode class=\"envar\"\u003eCOLUMNS\u003c/code\u003e, or the detected screen width if \u003ccode class=\"envar\"\u003eCOLUMNS\u003c/code\u003e is not set. In addition, if \u003ccode class=\"literal\"\u003ecolumns\u003c/code\u003e is zero then the \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e format only affects screen output. If \u003ccode class=\"literal\"\u003ecolumns\u003c/code\u003e is nonzero then file and pipe output is wrapped to that width as well.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-CSV-FIELDSEP\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003ecsv_fieldsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies the field separator to be used in CSV output format. If the separator character appears in a field's value, that field is output within double quotes, following standard CSV rules. The default is a comma.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-EXPANDED\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eexpanded\u003c/code\u003e (or \u003ccode class=\"literal\"\u003ex\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode class=\"literal\"\u003eon\u003c/code\u003e or \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e, which will enable or disable expanded mode, or \u003ccode class=\"literal\"\u003eauto\u003c/code\u003e. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e 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 \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ehorizontal\u003c/span\u003e”\u003c/span\u003e 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.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FIELDSEP\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003efieldsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies 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 \u003ccode class=\"literal\"\u003e\\pset fieldsep '\\t'\u003c/code\u003e. The default field separator is \u003ccode class=\"literal\"\u003e'|'\u003c/code\u003e (a vertical bar).\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FIELDSEP-ZERO\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003efieldsep_zero\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the field separator to use in unaligned output format to a zero byte.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FOOTER\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003efooter\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode class=\"literal\"\u003eon\u003c/code\u003e or \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e which will enable or disable display of the table footer (the \u003ccode class=\"literal\"\u003e(\u003cem class=\"replaceable\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e rows)\u003c/code\u003e count). If \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles footer display on or off.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FORMAT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eformat\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the output format to one of \u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e, \u003ccode class=\"literal\"\u003easciidoc\u003c/code\u003e, \u003ccode class=\"literal\"\u003ecsv\u003c/code\u003e, \u003ccode class=\"literal\"\u003ehtml\u003c/code\u003e, \u003ccode class=\"literal\"\u003elatex\u003c/code\u003e, \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e, \u003ccode class=\"literal\"\u003etroff-ms\u003c/code\u003e, \u003ccode class=\"literal\"\u003eunaligned\u003c/code\u003e, or \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e. Unique abbreviations are allowed.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e format is the standard, human-readable, nicely formatted text output; this is the default.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003eunaligned\u003c/code\u003e format writes all columns of a row on one line, separated by the currently active field separator. This is useful for creating output that might be intended to be read in by other programs, for example, tab-separated or comma-separated format. However, the field separator character is not treated specially if it appears in a column's value; so CSV format may be better suited for such purposes.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003ecsv\u003c/code\u003e format  writes column values separated by commas, applying the quoting rules described in \u003ca class=\"ulink\" href=\"https://datatracker.ietf.org/doc/html/rfc4180\"\u003eRFC 4180\u003c/a\u003e. This output is compatible with the CSV format of the server's \u003ccode class=\"command\"\u003eCOPY\u003c/code\u003e command. A header line with column names is generated unless the \u003ccode class=\"literal\"\u003etuples_only\u003c/code\u003e parameter is \u003ccode class=\"literal\"\u003eon\u003c/code\u003e. Titles and footers are not printed. Each row is terminated by the system-dependent end-of-line character, which is typically a single newline (\u003ccode class=\"literal\"\u003e\\n\u003c/code\u003e) for Unix-like systems or a carriage return and newline sequence (\u003ccode class=\"literal\"\u003e\\r\\n\u003c/code\u003e) for Microsoft Windows. Field separator characters other than comma can be selected with \u003ccode class=\"command\"\u003e\\pset csv_fieldsep\u003c/code\u003e.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e format is like \u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e but wraps wide data values across lines to make the output fit in the target column width. The target width is determined as described under the \u003ccode class=\"literal\"\u003ecolumns\u003c/code\u003e option. Note that \u003cspan class=\"application\"\u003epsql\u003c/span\u003e will not attempt to wrap column header titles; therefore, \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e format behaves the same as \u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e if the total width needed for column headers exceeds the target.\u003c/p\u003e\n\u003cp\u003eThe \u003ccode class=\"literal\"\u003easciidoc\u003c/code\u003e, \u003ccode class=\"literal\"\u003ehtml\u003c/code\u003e, \u003ccode class=\"literal\"\u003elatex\u003c/code\u003e, \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e, and \u003ccode class=\"literal\"\u003etroff-ms\u003c/code\u003e formats put out tables that are intended to be included in documents using the respective mark-up language. They are not complete documents! This might not be necessary in HTML, but in \u003cspan class=\"application\"\u003eLaTeX\u003c/span\u003e you must have a complete document wrapper. The \u003ccode class=\"literal\"\u003elatex\u003c/code\u003e format uses \u003cspan class=\"application\"\u003eLaTeX\u003c/span\u003e's \u003ccode class=\"literal\"\u003etabular\u003c/code\u003e environment. The \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e format requires the \u003cspan class=\"application\"\u003eLaTeX\u003c/span\u003e \u003ccode class=\"literal\"\u003elongtable\u003c/code\u003e and \u003ccode class=\"literal\"\u003ebooktabs\u003c/code\u003e packages.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-LINESTYLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003elinestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the border line drawing style to one of \u003ccode class=\"literal\"\u003eascii\u003c/code\u003e, \u003ccode class=\"literal\"\u003eold-ascii\u003c/code\u003e, or \u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e. Unique abbreviations are allowed. (That would mean one letter is enough.) The default setting is \u003ccode class=\"literal\"\u003eascii\u003c/code\u003e. This option only affects the \u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e and \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e output formats.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003eascii\u003c/code\u003e style uses plain ASCII characters. Newlines in data are shown using a \u003ccode class=\"literal\"\u003e+\u003c/code\u003e symbol in the right-hand margin. When the \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e format wraps data from one line to the next without a newline character, a dot (\u003ccode class=\"literal\"\u003e.\u003c/code\u003e) is shown in the right-hand margin of the first line, and again in the left-hand margin of the following line.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003eold-ascii\u003c/code\u003e style uses plain ASCII characters, using the formatting style used in \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 8.4 and earlier. Newlines in data are shown using a \u003ccode class=\"literal\"\u003e:\u003c/code\u003e symbol in place of the left-hand column separator. When the data is wrapped from one line to the next without a newline character, a \u003ccode class=\"literal\"\u003e;\u003c/code\u003e symbol is used in place of the left-hand column separator.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e style uses Unicode box-drawing characters. Newlines in data are shown using a carriage return symbol in the right-hand margin. When the data is wrapped from one line to the next without a newline character, an ellipsis symbol is shown in the right-hand margin of the first line, and again in the left-hand margin of the following line.\u003c/p\u003e\n\u003cp\u003eWhen the \u003ccode class=\"literal\"\u003eborder\u003c/code\u003e setting is greater than zero, the \u003ccode class=\"literal\"\u003elinestyle\u003c/code\u003e option also determines the characters with which the border lines are drawn. Plain ASCII characters work everywhere, but Unicode characters look nicer on displays that recognize them.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-NULL\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003enull\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the string to be printed in place of a null value. The default is to print nothing, which can easily be mistaken for an empty string. For example, one might prefer \u003ccode class=\"literal\"\u003e\\pset null '(null)'\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-NUMERICLOCALE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003enumericlocale\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode class=\"literal\"\u003eon\u003c/code\u003e or \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e which will enable or disable display of a locale-specific character to separate groups of digits to the left of the decimal marker. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles between regular and locale-specific numeric output.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-PAGER\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003epager\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eControls use of a pager program for query and \u003cspan class=\"application\"\u003epsql\u003c/span\u003e help output. When the \u003ccode class=\"literal\"\u003epager\u003c/code\u003e option is \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e, the pager program is not used. When the \u003ccode class=\"literal\"\u003epager\u003c/code\u003e option is \u003ccode class=\"literal\"\u003eon\u003c/code\u003e, the pager is used when appropriate, i.e., when the output is to a terminal and will not fit on the screen. The \u003ccode class=\"literal\"\u003epager\u003c/code\u003e option can also be set to \u003ccode class=\"literal\"\u003ealways\u003c/code\u003e, which causes the pager to be used for all terminal output regardless of whether it fits on the screen. \u003ccode class=\"literal\"\u003e\\pset pager\u003c/code\u003e without a \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e toggles pager use on and off.\u003c/p\u003e\n\u003cp\u003eIf the environment variable \u003ccode class=\"envar\"\u003ePSQL_PAGER\u003c/code\u003e or \u003ccode class=\"envar\"\u003ePAGER\u003c/code\u003e is set, output to be paged is piped to the specified program. Otherwise a platform-dependent default program (such as \u003ccode class=\"filename\"\u003emore\u003c/code\u003e) is used.\u003c/p\u003e\n\u003cp\u003eWhen using the \u003ccode class=\"literal\"\u003e\\watch\u003c/code\u003e command to execute a query repeatedly, the environment variable \u003ccode class=\"envar\"\u003ePSQL_WATCH_PAGER\u003c/code\u003e 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 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e's output format (such as \u003ccode class=\"filename\"\u003epspg --stream\u003c/code\u003e).\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-PAGER-MIN-LINES\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003epager_min_lines\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003ccode class=\"literal\"\u003epager_min_lines\u003c/code\u003e 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.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-RECORDSEP\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003erecordsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies the record (line) separator to use in unaligned output format. The default is a newline character.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-RECORDSEP-ZERO\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003erecordsep_zero\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the record separator to use in unaligned output format to a zero byte.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TABLEATTR\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003etableattr\u003c/code\u003e (or \u003ccode class=\"literal\"\u003eT\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIn HTML format, this specifies attributes to be placed inside the \u003ccode class=\"sgmltag-element\"\u003etable\u003c/code\u003e tag. This could for example be \u003ccode class=\"literal\"\u003ecellpadding\u003c/code\u003e or \u003ccode class=\"literal\"\u003ebgcolor\u003c/code\u003e. Note that you probably don't want to specify \u003ccode class=\"literal\"\u003eborder\u003c/code\u003e here, as that is already taken care of by \u003ccode class=\"literal\"\u003e\\pset border\u003c/code\u003e. If no \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is given, the table attributes are unset.\u003c/p\u003e\n\u003cp\u003eIn \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e 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., \u003ccode class=\"literal\"\u003e'0.2 0.2 0.6'\u003c/code\u003e. Unspecified output columns use the last specified value.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TITLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003etitle\u003c/code\u003e (or \u003ccode class=\"literal\"\u003eC\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the table title for any subsequently printed tables. This can be used to give your output descriptive tags. If no \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is given, the title is unset.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TUPLES-ONLY\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003etuples_only\u003c/code\u003e (or \u003ccode class=\"literal\"\u003et\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode class=\"literal\"\u003eon\u003c/code\u003e or \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e which will enable or disable tuples-only mode. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles between regular and tuples-only output. Regular output includes extra information such as column headers, titles, and various footers. In tuples-only mode, only actual table data is shown.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-BORDER-LINESTYLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eunicode_border_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the border drawing style for the \u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e line style to one of \u003ccode class=\"literal\"\u003esingle\u003c/code\u003e or \u003ccode class=\"literal\"\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-COLUMN-LINESTYLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eunicode_column_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the column drawing style for the \u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e line style to one of \u003ccode class=\"literal\"\u003esingle\u003c/code\u003e or \u003ccode class=\"literal\"\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-HEADER-LINESTYLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eunicode_header_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the header drawing style for the \u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e line style to one of \u003ccode class=\"literal\"\u003esingle\u003c/code\u003e or \u003ccode class=\"literal\"\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-XHEADER-WIDTH\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003exheader_width\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the maximum width of the header for expanded output to one of \u003ccode class=\"literal\"\u003efull\u003c/code\u003e (the default value), \u003ccode class=\"literal\"\u003ecolumn\u003c/code\u003e, \u003ccode class=\"literal\"\u003epage\u003c/code\u003e, or an \u003cem class=\"replaceable\"\u003e\u003ccode\u003einteger value\u003c/code\u003e\u003c/em\u003e.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003efull\u003c/code\u003e: the expanded header is not truncated, and will be as wide as the widest output line.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003ecolumn\u003c/code\u003e: truncate the header line to the width of the first column.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003epage\u003c/code\u003e: truncate the header line to the terminal width.\u003c/p\u003e\n\u003cp\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003einteger value\u003c/code\u003e\u003c/em\u003e: specify the exact maximum width of the header line.\u003c/p\u003e\n\u003c/dd\u003e\n\u003c/dl\u003e\n\u003c/div\u003e\n\u003cp\u003eIllustrations of how these different formats look can be seen in \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-EXAMPLES\" title=\"Examples\"\u003eExamples\u003c/a\u003e, below.\u003c/p\u003e\n\u003cdiv class=\"tip\"\u003e\n\u003ch3 class=\"title\"\u003eTip\u003c/h3\u003e\n\u003cp\u003eThere are various shortcut commands for \u003ccode class=\"command\"\u003e\\pset\u003c/code\u003e. See \u003ccode class=\"command\"\u003e\\a\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\C\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\f\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\H\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\t\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\T\u003c/code\u003e, and \u003ccode class=\"command\"\u003e\\x\u003c/code\u003e.\u003c/p\u003e\n\u003c/div\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-PSET","modifiers":[],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[],"signature":"\\pset [ option [ value ] ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-PSET","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-PSET"}],"spellings":["\\pset"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\pset","url":"/wiki/psql/cmd-70-73-65-74/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-PSET","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-PSET","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-PSET"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-70-73-65-74","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\pset","Summary":"This command sets options affecting the output of query result tables. option indicates which option is to be set. The semantics of value vary depending on the selected option. For some options, omitting value causes the option to be toggled or unset, as described under the particular option. If no such behavior is mentioned, then omitting value just results in the current setting being displayed.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-PSET\"\u003e\u003cspan\u003e\u003ccode\u003e\\pset [ \u003cem\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e [ \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eThis command sets options affecting the output of query result tables. \u003cem\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e indicates which option is to be set. The semantics of \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e vary depending on the selected option. For some options, omitting \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e causes the option to be toggled or unset, as described under the particular option. If no such behavior is mentioned, then omitting \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e just results in the current setting being displayed.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003e\\pset\u003c/code\u003e without any arguments displays the current status of all printing options.\u003c/p\u003e\n\u003cp\u003eAdjustable printing options are:\u003c/p\u003e\n\u003cdiv\u003e\n\u003cdl\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-BORDER\"\u003e\u003cspan\u003e\u003ccode\u003eborder\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e 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 HTML format, this will translate directly into the \u003ccode\u003eborder=...\u003c/code\u003e 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 \u003ccode\u003eborder = 2\u003c/code\u003e. The \u003ccode\u003elatex\u003c/code\u003e and \u003ccode\u003elatex-longtable\u003c/code\u003e formats additionally allow a value of 3 to add dividing lines between data rows.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-COLUMNS\"\u003e\u003cspan\u003e\u003ccode\u003ecolumns\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the target width for the \u003ccode\u003ewrapped\u003c/code\u003e 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 \u003ccode\u003eCOLUMNS\u003c/code\u003e, or the detected screen width if \u003ccode\u003eCOLUMNS\u003c/code\u003e is not set. In addition, if \u003ccode\u003ecolumns\u003c/code\u003e is zero then the \u003ccode\u003ewrapped\u003c/code\u003e format only affects screen output. If \u003ccode\u003ecolumns\u003c/code\u003e is nonzero then file and pipe output is wrapped to that width as well.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-CSV-FIELDSEP\"\u003e\u003cspan\u003e\u003ccode\u003ecsv_fieldsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies the field separator to be used in CSV output format. If the separator character appears in a field\u0026#39;s value, that field is output within double quotes, following standard CSV rules. The default is a comma.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-EXPANDED\"\u003e\u003cspan\u003e\u003ccode\u003eexpanded\u003c/code\u003e (or \u003ccode\u003ex\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode\u003eon\u003c/code\u003e or \u003ccode\u003eoff\u003c/code\u003e, which will enable or disable expanded mode, or \u003ccode\u003eauto\u003c/code\u003e. If \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e 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\u0026#39;t fit on the screen in the normal \u003cspan\u003e“\u003cspan\u003ehorizontal\u003c/span\u003e”\u003c/span\u003e 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.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FIELDSEP\"\u003e\u003cspan\u003e\u003ccode\u003efieldsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies 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 \u003ccode\u003e\\pset fieldsep \u0026#39;\\t\u0026#39;\u003c/code\u003e. The default field separator is \u003ccode\u003e\u0026#39;|\u0026#39;\u003c/code\u003e (a vertical bar).\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FIELDSEP-ZERO\"\u003e\u003cspan\u003e\u003ccode\u003efieldsep_zero\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the field separator to use in unaligned output format to a zero byte.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FOOTER\"\u003e\u003cspan\u003e\u003ccode\u003efooter\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode\u003eon\u003c/code\u003e or \u003ccode\u003eoff\u003c/code\u003e which will enable or disable display of the table footer (the \u003ccode\u003e(\u003cem\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e rows)\u003c/code\u003e count). If \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles footer display on or off.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FORMAT\"\u003e\u003cspan\u003e\u003ccode\u003eformat\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the output format to one of \u003ccode\u003ealigned\u003c/code\u003e, \u003ccode\u003easciidoc\u003c/code\u003e, \u003ccode\u003ecsv\u003c/code\u003e, \u003ccode\u003ehtml\u003c/code\u003e, \u003ccode\u003elatex\u003c/code\u003e, \u003ccode\u003elatex-longtable\u003c/code\u003e, \u003ccode\u003etroff-ms\u003c/code\u003e, \u003ccode\u003eunaligned\u003c/code\u003e, or \u003ccode\u003ewrapped\u003c/code\u003e. Unique abbreviations are allowed.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003ealigned\u003c/code\u003e format is the standard, human-readable, nicely formatted text output; this is the default.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003eunaligned\u003c/code\u003e format writes all columns of a row on one line, separated by the currently active field separator. This is useful for creating output that might be intended to be read in by other programs, for example, tab-separated or comma-separated format. However, the field separator character is not treated specially if it appears in a column\u0026#39;s value; so CSV format may be better suited for such purposes.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003ecsv\u003c/code\u003e format  writes column values separated by commas, applying the quoting rules described in \u003ca href=\"https://datatracker.ietf.org/doc/html/rfc4180\" rel=\"nofollow\"\u003eRFC 4180\u003c/a\u003e. This output is compatible with the CSV format of the server\u0026#39;s \u003ccode\u003eCOPY\u003c/code\u003e command. A header line with column names is generated unless the \u003ccode\u003etuples_only\u003c/code\u003e parameter is \u003ccode\u003eon\u003c/code\u003e. Titles and footers are not printed. Each row is terminated by the system-dependent end-of-line character, which is typically a single newline (\u003ccode\u003e\\n\u003c/code\u003e) for Unix-like systems or a carriage return and newline sequence (\u003ccode\u003e\\r\\n\u003c/code\u003e) for Microsoft Windows. Field separator characters other than comma can be selected with \u003ccode\u003e\\pset csv_fieldsep\u003c/code\u003e.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003ewrapped\u003c/code\u003e format is like \u003ccode\u003ealigned\u003c/code\u003e but wraps wide data values across lines to make the output fit in the target column width. The target width is determined as described under the \u003ccode\u003ecolumns\u003c/code\u003e option. Note that \u003cspan\u003epsql\u003c/span\u003e will not attempt to wrap column header titles; therefore, \u003ccode\u003ewrapped\u003c/code\u003e format behaves the same as \u003ccode\u003ealigned\u003c/code\u003e if the total width needed for column headers exceeds the target.\u003c/p\u003e\n\u003cp\u003eThe \u003ccode\u003easciidoc\u003c/code\u003e, \u003ccode\u003ehtml\u003c/code\u003e, \u003ccode\u003elatex\u003c/code\u003e, \u003ccode\u003elatex-longtable\u003c/code\u003e, and \u003ccode\u003etroff-ms\u003c/code\u003e formats put out tables that are intended to be included in documents using the respective mark-up language. They are not complete documents! This might not be necessary in HTML, but in \u003cspan\u003eLaTeX\u003c/span\u003e you must have a complete document wrapper. The \u003ccode\u003elatex\u003c/code\u003e format uses \u003cspan\u003eLaTeX\u003c/span\u003e\u0026#39;s \u003ccode\u003etabular\u003c/code\u003e environment. The \u003ccode\u003elatex-longtable\u003c/code\u003e format requires the \u003cspan\u003eLaTeX\u003c/span\u003e \u003ccode\u003elongtable\u003c/code\u003e and \u003ccode\u003ebooktabs\u003c/code\u003e packages.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-LINESTYLE\"\u003e\u003cspan\u003e\u003ccode\u003elinestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the border line drawing style to one of \u003ccode\u003eascii\u003c/code\u003e, \u003ccode\u003eold-ascii\u003c/code\u003e, or \u003ccode\u003eunicode\u003c/code\u003e. Unique abbreviations are allowed. (That would mean one letter is enough.) The default setting is \u003ccode\u003eascii\u003c/code\u003e. This option only affects the \u003ccode\u003ealigned\u003c/code\u003e and \u003ccode\u003ewrapped\u003c/code\u003e output formats.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003eascii\u003c/code\u003e style uses plain ASCII characters. Newlines in data are shown using a \u003ccode\u003e+\u003c/code\u003e symbol in the right-hand margin. When the \u003ccode\u003ewrapped\u003c/code\u003e format wraps data from one line to the next without a newline character, a dot (\u003ccode\u003e.\u003c/code\u003e) is shown in the right-hand margin of the first line, and again in the left-hand margin of the following line.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003eold-ascii\u003c/code\u003e style uses plain ASCII characters, using the formatting style used in \u003cspan\u003ePostgreSQL\u003c/span\u003e 8.4 and earlier. Newlines in data are shown using a \u003ccode\u003e:\u003c/code\u003e symbol in place of the left-hand column separator. When the data is wrapped from one line to the next without a newline character, a \u003ccode\u003e;\u003c/code\u003e symbol is used in place of the left-hand column separator.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003eunicode\u003c/code\u003e style uses Unicode box-drawing characters. Newlines in data are shown using a carriage return symbol in the right-hand margin. When the data is wrapped from one line to the next without a newline character, an ellipsis symbol is shown in the right-hand margin of the first line, and again in the left-hand margin of the following line.\u003c/p\u003e\n\u003cp\u003eWhen the \u003ccode\u003eborder\u003c/code\u003e setting is greater than zero, the \u003ccode\u003elinestyle\u003c/code\u003e option also determines the characters with which the border lines are drawn. Plain ASCII characters work everywhere, but Unicode characters look nicer on displays that recognize them.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-NULL\"\u003e\u003cspan\u003e\u003ccode\u003enull\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the string to be printed in place of a null value. The default is to print nothing, which can easily be mistaken for an empty string. For example, one might prefer \u003ccode\u003e\\pset null \u0026#39;(null)\u0026#39;\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-NUMERICLOCALE\"\u003e\u003cspan\u003e\u003ccode\u003enumericlocale\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode\u003eon\u003c/code\u003e or \u003ccode\u003eoff\u003c/code\u003e which will enable or disable display of a locale-specific character to separate groups of digits to the left of the decimal marker. If \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles between regular and locale-specific numeric output.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-PAGER\"\u003e\u003cspan\u003e\u003ccode\u003epager\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eControls use of a pager program for query and \u003cspan\u003epsql\u003c/span\u003e help output. When the \u003ccode\u003epager\u003c/code\u003e option is \u003ccode\u003eoff\u003c/code\u003e, the pager program is not used. When the \u003ccode\u003epager\u003c/code\u003e option is \u003ccode\u003eon\u003c/code\u003e, the pager is used when appropriate, i.e., when the output is to a terminal and will not fit on the screen. The \u003ccode\u003epager\u003c/code\u003e option can also be set to \u003ccode\u003ealways\u003c/code\u003e, which causes the pager to be used for all terminal output regardless of whether it fits on the screen. \u003ccode\u003e\\pset pager\u003c/code\u003e without a \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e toggles pager use on and off.\u003c/p\u003e\n\u003cp\u003eIf the environment variable \u003ccode\u003ePSQL_PAGER\u003c/code\u003e or \u003ccode\u003ePAGER\u003c/code\u003e is set, output to be paged is piped to the specified program. Otherwise a platform-dependent default program (such as \u003ccode\u003emore\u003c/code\u003e) is used.\u003c/p\u003e\n\u003cp\u003eWhen using the \u003ccode\u003e\\watch\u003c/code\u003e command to execute a query repeatedly, the environment variable \u003ccode\u003ePSQL_WATCH_PAGER\u003c/code\u003e 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 \u003cspan\u003epsql\u003c/span\u003e\u0026#39;s output format (such as \u003ccode\u003epspg --stream\u003c/code\u003e).\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-PAGER-MIN-LINES\"\u003e\u003cspan\u003e\u003ccode\u003epager_min_lines\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003ccode\u003epager_min_lines\u003c/code\u003e 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.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-RECORDSEP\"\u003e\u003cspan\u003e\u003ccode\u003erecordsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies the record (line) separator to use in unaligned output format. The default is a newline character.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-RECORDSEP-ZERO\"\u003e\u003cspan\u003e\u003ccode\u003erecordsep_zero\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the record separator to use in unaligned output format to a zero byte.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TABLEATTR\"\u003e\u003cspan\u003e\u003ccode\u003etableattr\u003c/code\u003e (or \u003ccode\u003eT\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIn HTML format, this specifies attributes to be placed inside the \u003ccode\u003etable\u003c/code\u003e tag. This could for example be \u003ccode\u003ecellpadding\u003c/code\u003e or \u003ccode\u003ebgcolor\u003c/code\u003e. Note that you probably don\u0026#39;t want to specify \u003ccode\u003eborder\u003c/code\u003e here, as that is already taken care of by \u003ccode\u003e\\pset border\u003c/code\u003e. If no \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is given, the table attributes are unset.\u003c/p\u003e\n\u003cp\u003eIn \u003ccode\u003elatex-longtable\u003c/code\u003e 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., \u003ccode\u003e\u0026#39;0.2 0.2 0.6\u0026#39;\u003c/code\u003e. Unspecified output columns use the last specified value.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TITLE\"\u003e\u003cspan\u003e\u003ccode\u003etitle\u003c/code\u003e (or \u003ccode\u003eC\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the table title for any subsequently printed tables. This can be used to give your output descriptive tags. If no \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is given, the title is unset.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TUPLES-ONLY\"\u003e\u003cspan\u003e\u003ccode\u003etuples_only\u003c/code\u003e (or \u003ccode\u003et\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode\u003eon\u003c/code\u003e or \u003ccode\u003eoff\u003c/code\u003e which will enable or disable tuples-only mode. If \u003cem\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles between regular and tuples-only output. Regular output includes extra information such as column headers, titles, and various footers. In tuples-only mode, only actual table data is shown.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-BORDER-LINESTYLE\"\u003e\u003cspan\u003e\u003ccode\u003eunicode_border_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the border drawing style for the \u003ccode\u003eunicode\u003c/code\u003e line style to one of \u003ccode\u003esingle\u003c/code\u003e or \u003ccode\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-COLUMN-LINESTYLE\"\u003e\u003cspan\u003e\u003ccode\u003eunicode_column_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the column drawing style for the \u003ccode\u003eunicode\u003c/code\u003e line style to one of \u003ccode\u003esingle\u003c/code\u003e or \u003ccode\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-HEADER-LINESTYLE\"\u003e\u003cspan\u003e\u003ccode\u003eunicode_header_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the header drawing style for the \u003ccode\u003eunicode\u003c/code\u003e line style to one of \u003ccode\u003esingle\u003c/code\u003e or \u003ccode\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-XHEADER-WIDTH\"\u003e\u003cspan\u003e\u003ccode\u003exheader_width\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the maximum width of the header for expanded output to one of \u003ccode\u003efull\u003c/code\u003e (the default value), \u003ccode\u003ecolumn\u003c/code\u003e, \u003ccode\u003epage\u003c/code\u003e, or an \u003cem\u003e\u003ccode\u003einteger value\u003c/code\u003e\u003c/em\u003e.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003efull\u003c/code\u003e: the expanded header is not truncated, and will be as wide as the widest output line.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003ecolumn\u003c/code\u003e: truncate the header line to the width of the first column.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003epage\u003c/code\u003e: truncate the header line to the terminal width.\u003c/p\u003e\n\u003cp\u003e\u003cem\u003e\u003ccode\u003einteger value\u003c/code\u003e\u003c/em\u003e: specify the exact maximum width of the header line.\u003c/p\u003e\n\u003c/dd\u003e\n\u003c/dl\u003e\n\u003c/div\u003e\n\u003cp\u003eIllustrations of how these different formats look can be seen in \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-EXAMPLES\" title=\"Examples\" rel=\"nofollow\"\u003eExamples\u003c/a\u003e, below.\u003c/p\u003e\n\u003cdiv\u003e\n\u003ch3\u003eTip\u003c/h3\u003e\n\u003cp\u003eThere are various shortcut commands for \u003ccode\u003e\\pset\u003c/code\u003e. See \u003ccode\u003e\\a\u003c/code\u003e, \u003ccode\u003e\\C\u003c/code\u003e, \u003ccode\u003e\\f\u003c/code\u003e, \u003ccode\u003e\\H\u003c/code\u003e, \u003ccode\u003e\\t\u003c/code\u003e, \u003ccode\u003e\\T\u003c/code\u003e, and \u003ccode\u003e\\x\u003c/code\u003e.\u003c/p\u003e\n\u003c/div\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"ffd80213292656c2d5f93e91bf952128739034c3c33a1bb5eabc34c61e206936","Payload":{"description":["This command sets options affecting the output of query result tables. option indicates which option is to be set. The semantics of value vary depending on the selected option. For some options, omitting value causes the option to be toggled or unset, as described under the particular option. If no such behavior is mentioned, then omitting value just results in the current setting being displayed."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-PSET\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\pset [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eThis command sets options affecting the output of query result tables. \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e indicates which option is to be set. The semantics of \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e vary depending on the selected option. For some options, omitting \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e causes the option to be toggled or unset, as described under the particular option. If no such behavior is mentioned, then omitting \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e just results in the current setting being displayed.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"command\"\u003e\\pset\u003c/code\u003e without any arguments displays the current status of all printing options.\u003c/p\u003e\n\u003cp\u003eAdjustable printing options are:\u003c/p\u003e\n\u003cdiv class=\"variablelist\"\u003e\n\u003cdl class=\"variablelist\"\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-BORDER\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eborder\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e 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 HTML format, this will translate directly into the \u003ccode class=\"literal\"\u003eborder=...\u003c/code\u003e 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 \u003ccode class=\"literal\"\u003eborder = 2\u003c/code\u003e. The \u003ccode class=\"literal\"\u003elatex\u003c/code\u003e and \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e formats additionally allow a value of 3 to add dividing lines between data rows.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-COLUMNS\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003ecolumns\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the target width for the \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e 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 \u003ccode class=\"envar\"\u003eCOLUMNS\u003c/code\u003e, or the detected screen width if \u003ccode class=\"envar\"\u003eCOLUMNS\u003c/code\u003e is not set. In addition, if \u003ccode class=\"literal\"\u003ecolumns\u003c/code\u003e is zero then the \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e format only affects screen output. If \u003ccode class=\"literal\"\u003ecolumns\u003c/code\u003e is nonzero then file and pipe output is wrapped to that width as well.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-CSV-FIELDSEP\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003ecsv_fieldsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies the field separator to be used in CSV output format. If the separator character appears in a field's value, that field is output within double quotes, following standard CSV rules. The default is a comma.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-EXPANDED\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eexpanded\u003c/code\u003e (or \u003ccode class=\"literal\"\u003ex\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode class=\"literal\"\u003eon\u003c/code\u003e or \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e, which will enable or disable expanded mode, or \u003ccode class=\"literal\"\u003eauto\u003c/code\u003e. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e 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 \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ehorizontal\u003c/span\u003e”\u003c/span\u003e 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.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FIELDSEP\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003efieldsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies 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 \u003ccode class=\"literal\"\u003e\\pset fieldsep '\\t'\u003c/code\u003e. The default field separator is \u003ccode class=\"literal\"\u003e'|'\u003c/code\u003e (a vertical bar).\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FIELDSEP-ZERO\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003efieldsep_zero\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the field separator to use in unaligned output format to a zero byte.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FOOTER\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003efooter\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode class=\"literal\"\u003eon\u003c/code\u003e or \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e which will enable or disable display of the table footer (the \u003ccode class=\"literal\"\u003e(\u003cem class=\"replaceable\"\u003e\u003ccode\u003en\u003c/code\u003e\u003c/em\u003e rows)\u003c/code\u003e count). If \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles footer display on or off.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-FORMAT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eformat\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the output format to one of \u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e, \u003ccode class=\"literal\"\u003easciidoc\u003c/code\u003e, \u003ccode class=\"literal\"\u003ecsv\u003c/code\u003e, \u003ccode class=\"literal\"\u003ehtml\u003c/code\u003e, \u003ccode class=\"literal\"\u003elatex\u003c/code\u003e, \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e, \u003ccode class=\"literal\"\u003etroff-ms\u003c/code\u003e, \u003ccode class=\"literal\"\u003eunaligned\u003c/code\u003e, or \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e. Unique abbreviations are allowed.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e format is the standard, human-readable, nicely formatted text output; this is the default.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003eunaligned\u003c/code\u003e format writes all columns of a row on one line, separated by the currently active field separator. This is useful for creating output that might be intended to be read in by other programs, for example, tab-separated or comma-separated format. However, the field separator character is not treated specially if it appears in a column's value; so CSV format may be better suited for such purposes.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003ecsv\u003c/code\u003e format  writes column values separated by commas, applying the quoting rules described in \u003ca class=\"ulink\" href=\"https://datatracker.ietf.org/doc/html/rfc4180\"\u003eRFC 4180\u003c/a\u003e. This output is compatible with the CSV format of the server's \u003ccode class=\"command\"\u003eCOPY\u003c/code\u003e command. A header line with column names is generated unless the \u003ccode class=\"literal\"\u003etuples_only\u003c/code\u003e parameter is \u003ccode class=\"literal\"\u003eon\u003c/code\u003e. Titles and footers are not printed. Each row is terminated by the system-dependent end-of-line character, which is typically a single newline (\u003ccode class=\"literal\"\u003e\\n\u003c/code\u003e) for Unix-like systems or a carriage return and newline sequence (\u003ccode class=\"literal\"\u003e\\r\\n\u003c/code\u003e) for Microsoft Windows. Field separator characters other than comma can be selected with \u003ccode class=\"command\"\u003e\\pset csv_fieldsep\u003c/code\u003e.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e format is like \u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e but wraps wide data values across lines to make the output fit in the target column width. The target width is determined as described under the \u003ccode class=\"literal\"\u003ecolumns\u003c/code\u003e option. Note that \u003cspan class=\"application\"\u003epsql\u003c/span\u003e will not attempt to wrap column header titles; therefore, \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e format behaves the same as \u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e if the total width needed for column headers exceeds the target.\u003c/p\u003e\n\u003cp\u003eThe \u003ccode class=\"literal\"\u003easciidoc\u003c/code\u003e, \u003ccode class=\"literal\"\u003ehtml\u003c/code\u003e, \u003ccode class=\"literal\"\u003elatex\u003c/code\u003e, \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e, and \u003ccode class=\"literal\"\u003etroff-ms\u003c/code\u003e formats put out tables that are intended to be included in documents using the respective mark-up language. They are not complete documents! This might not be necessary in HTML, but in \u003cspan class=\"application\"\u003eLaTeX\u003c/span\u003e you must have a complete document wrapper. The \u003ccode class=\"literal\"\u003elatex\u003c/code\u003e format uses \u003cspan class=\"application\"\u003eLaTeX\u003c/span\u003e's \u003ccode class=\"literal\"\u003etabular\u003c/code\u003e environment. The \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e format requires the \u003cspan class=\"application\"\u003eLaTeX\u003c/span\u003e \u003ccode class=\"literal\"\u003elongtable\u003c/code\u003e and \u003ccode class=\"literal\"\u003ebooktabs\u003c/code\u003e packages.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-LINESTYLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003elinestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the border line drawing style to one of \u003ccode class=\"literal\"\u003eascii\u003c/code\u003e, \u003ccode class=\"literal\"\u003eold-ascii\u003c/code\u003e, or \u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e. Unique abbreviations are allowed. (That would mean one letter is enough.) The default setting is \u003ccode class=\"literal\"\u003eascii\u003c/code\u003e. This option only affects the \u003ccode class=\"literal\"\u003ealigned\u003c/code\u003e and \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e output formats.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003eascii\u003c/code\u003e style uses plain ASCII characters. Newlines in data are shown using a \u003ccode class=\"literal\"\u003e+\u003c/code\u003e symbol in the right-hand margin. When the \u003ccode class=\"literal\"\u003ewrapped\u003c/code\u003e format wraps data from one line to the next without a newline character, a dot (\u003ccode class=\"literal\"\u003e.\u003c/code\u003e) is shown in the right-hand margin of the first line, and again in the left-hand margin of the following line.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003eold-ascii\u003c/code\u003e style uses plain ASCII characters, using the formatting style used in \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 8.4 and earlier. Newlines in data are shown using a \u003ccode class=\"literal\"\u003e:\u003c/code\u003e symbol in place of the left-hand column separator. When the data is wrapped from one line to the next without a newline character, a \u003ccode class=\"literal\"\u003e;\u003c/code\u003e symbol is used in place of the left-hand column separator.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e style uses Unicode box-drawing characters. Newlines in data are shown using a carriage return symbol in the right-hand margin. When the data is wrapped from one line to the next without a newline character, an ellipsis symbol is shown in the right-hand margin of the first line, and again in the left-hand margin of the following line.\u003c/p\u003e\n\u003cp\u003eWhen the \u003ccode class=\"literal\"\u003eborder\u003c/code\u003e setting is greater than zero, the \u003ccode class=\"literal\"\u003elinestyle\u003c/code\u003e option also determines the characters with which the border lines are drawn. Plain ASCII characters work everywhere, but Unicode characters look nicer on displays that recognize them.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-NULL\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003enull\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the string to be printed in place of a null value. The default is to print nothing, which can easily be mistaken for an empty string. For example, one might prefer \u003ccode class=\"literal\"\u003e\\pset null '(null)'\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-NUMERICLOCALE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003enumericlocale\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode class=\"literal\"\u003eon\u003c/code\u003e or \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e which will enable or disable display of a locale-specific character to separate groups of digits to the left of the decimal marker. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles between regular and locale-specific numeric output.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-PAGER\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003epager\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eControls use of a pager program for query and \u003cspan class=\"application\"\u003epsql\u003c/span\u003e help output. When the \u003ccode class=\"literal\"\u003epager\u003c/code\u003e option is \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e, the pager program is not used. When the \u003ccode class=\"literal\"\u003epager\u003c/code\u003e option is \u003ccode class=\"literal\"\u003eon\u003c/code\u003e, the pager is used when appropriate, i.e., when the output is to a terminal and will not fit on the screen. The \u003ccode class=\"literal\"\u003epager\u003c/code\u003e option can also be set to \u003ccode class=\"literal\"\u003ealways\u003c/code\u003e, which causes the pager to be used for all terminal output regardless of whether it fits on the screen. \u003ccode class=\"literal\"\u003e\\pset pager\u003c/code\u003e without a \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e toggles pager use on and off.\u003c/p\u003e\n\u003cp\u003eIf the environment variable \u003ccode class=\"envar\"\u003ePSQL_PAGER\u003c/code\u003e or \u003ccode class=\"envar\"\u003ePAGER\u003c/code\u003e is set, output to be paged is piped to the specified program. Otherwise a platform-dependent default program (such as \u003ccode class=\"filename\"\u003emore\u003c/code\u003e) is used.\u003c/p\u003e\n\u003cp\u003eWhen using the \u003ccode class=\"literal\"\u003e\\watch\u003c/code\u003e command to execute a query repeatedly, the environment variable \u003ccode class=\"envar\"\u003ePSQL_WATCH_PAGER\u003c/code\u003e 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 \u003cspan class=\"application\"\u003epsql\u003c/span\u003e's output format (such as \u003ccode class=\"filename\"\u003epspg --stream\u003c/code\u003e).\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-PAGER-MIN-LINES\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003epager_min_lines\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003ccode class=\"literal\"\u003epager_min_lines\u003c/code\u003e 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.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-RECORDSEP\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003erecordsep\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSpecifies the record (line) separator to use in unaligned output format. The default is a newline character.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-RECORDSEP-ZERO\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003erecordsep_zero\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the record separator to use in unaligned output format to a zero byte.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TABLEATTR\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003etableattr\u003c/code\u003e (or \u003ccode class=\"literal\"\u003eT\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIn HTML format, this specifies attributes to be placed inside the \u003ccode class=\"sgmltag-element\"\u003etable\u003c/code\u003e tag. This could for example be \u003ccode class=\"literal\"\u003ecellpadding\u003c/code\u003e or \u003ccode class=\"literal\"\u003ebgcolor\u003c/code\u003e. Note that you probably don't want to specify \u003ccode class=\"literal\"\u003eborder\u003c/code\u003e here, as that is already taken care of by \u003ccode class=\"literal\"\u003e\\pset border\u003c/code\u003e. If no \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is given, the table attributes are unset.\u003c/p\u003e\n\u003cp\u003eIn \u003ccode class=\"literal\"\u003elatex-longtable\u003c/code\u003e 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., \u003ccode class=\"literal\"\u003e'0.2 0.2 0.6'\u003c/code\u003e. Unspecified output columns use the last specified value.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TITLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003etitle\u003c/code\u003e (or \u003ccode class=\"literal\"\u003eC\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the table title for any subsequently printed tables. This can be used to give your output descriptive tags. If no \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is given, the title is unset.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-TUPLES-ONLY\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003etuples_only\u003c/code\u003e (or \u003ccode class=\"literal\"\u003et\u003c/code\u003e)\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eIf \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is specified it must be either \u003ccode class=\"literal\"\u003eon\u003c/code\u003e or \u003ccode class=\"literal\"\u003eoff\u003c/code\u003e which will enable or disable tuples-only mode. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e is omitted the command toggles between regular and tuples-only output. Regular output includes extra information such as column headers, titles, and various footers. In tuples-only mode, only actual table data is shown.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-BORDER-LINESTYLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eunicode_border_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the border drawing style for the \u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e line style to one of \u003ccode class=\"literal\"\u003esingle\u003c/code\u003e or \u003ccode class=\"literal\"\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-COLUMN-LINESTYLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eunicode_column_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the column drawing style for the \u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e line style to one of \u003ccode class=\"literal\"\u003esingle\u003c/code\u003e or \u003ccode class=\"literal\"\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-UNICODE-HEADER-LINESTYLE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eunicode_header_linestyle\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the header drawing style for the \u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e line style to one of \u003ccode class=\"literal\"\u003esingle\u003c/code\u003e or \u003ccode class=\"literal\"\u003edouble\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt id=\"APP-PSQL-META-COMMAND-PSET-XHEADER-WIDTH\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003exheader_width\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eSets the maximum width of the header for expanded output to one of \u003ccode class=\"literal\"\u003efull\u003c/code\u003e (the default value), \u003ccode class=\"literal\"\u003ecolumn\u003c/code\u003e, \u003ccode class=\"literal\"\u003epage\u003c/code\u003e, or an \u003cem class=\"replaceable\"\u003e\u003ccode\u003einteger value\u003c/code\u003e\u003c/em\u003e.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003efull\u003c/code\u003e: the expanded header is not truncated, and will be as wide as the widest output line.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003ecolumn\u003c/code\u003e: truncate the header line to the width of the first column.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003epage\u003c/code\u003e: truncate the header line to the terminal width.\u003c/p\u003e\n\u003cp\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003einteger value\u003c/code\u003e\u003c/em\u003e: specify the exact maximum width of the header line.\u003c/p\u003e\n\u003c/dd\u003e\n\u003c/dl\u003e\n\u003c/div\u003e\n\u003cp\u003eIllustrations of how these different formats look can be seen in \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-EXAMPLES\" title=\"Examples\"\u003eExamples\u003c/a\u003e, below.\u003c/p\u003e\n\u003cdiv class=\"tip\"\u003e\n\u003ch3 class=\"title\"\u003eTip\u003c/h3\u003e\n\u003cp\u003eThere are various shortcut commands for \u003ccode class=\"command\"\u003e\\pset\u003c/code\u003e. See \u003ccode class=\"command\"\u003e\\a\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\C\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\f\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\H\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\t\u003c/code\u003e, \u003ccode class=\"command\"\u003e\\T\u003c/code\u003e, and \u003ccode class=\"command\"\u003e\\x\u003c/code\u003e.\u003c/p\u003e\n\u003c/div\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\pset","url":"/wiki/psql/cmd-70-73-65-74/?v=18"},"modifiers":"None listed in this signature"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\pset","Signature":"\\pset [ option [ value ] ]","Modifiers":[]}],"SQLState":null,"Evidence":null}