{"Entry":{"collection":"psql","key":"cmd-6f-75-74","name":"\\out","aliases":["\\out"],"metadata":{"aliases":["\\out"],"category":"Output and formatting","content_hash":"96f6d46f9c005a7668d4e1c15d83c7a85066f14f27a2c50939dbc2e6f0b6f65d","imported_at":"2026-09-30T00:40:45.118749+08:00","name":"\\out","name_zh":"","slug":"cmd-6f-75-74","summary":"Arranges to save future query results to the file filename or pipe future results to the shell command command . If no argument is specified, the query output is reset to the standard output."}},"Definition":{"Collection":"psql","Key":"cmd-6f-75-74","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-6f-75-74","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","Facts":{"command":"\\out","comparison_data":{"definition":"Arranges to save future query results to the file filename or pipe future results to the shell command command . If no argument is specified, the query output is reset to the standard output. If the argument begins with | , then the entire remainder of the line is taken to be the command to execute, and neither variable interpolation nor backquote expansion are performed in it. The rest of the line is simply passed literally to the shell. “ Query results ” includes all tables, command responses, and notices obtained from the database server, as well as output of various backslash commands that query the database (such as \\d ); but not error messages. Tip To intersperse text output in between query results, use \\qecho .","modifiers":[],"signature":"\\o or \\out [ filename ] \\o or \\out [ | command ]","spellings":["\\o","\\out"]},"comparison_hash":"0eda1bf36a0ebb2330c184debf875d5e118947f3a4cedc0d73e41ffe08a6bf50","description":["Arranges to save future query results to the file filename or pipe future results to the shell command command . If no argument is specified, the query output is reset to the standard output."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\out"}],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-OUT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\o\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\out [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\o\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\out [ |\u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eArranges to save future query results to the file \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipe future results to the shell command \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e. If no argument is specified, the query output is reset to the standard output.\u003c/p\u003e\n\u003cp\u003eIf the argument begins with \u003ccode class=\"literal\"\u003e|\u003c/code\u003e, then the entire remainder of the line is taken to be the \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e to execute, and neither variable interpolation nor backquote expansion are performed in it. The rest of the line is simply passed literally to the shell.\u003c/p\u003e\n\u003cp\u003e\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eQuery results\u003c/span\u003e”\u003c/span\u003e includes all tables, command responses, and notices obtained from the database server, as well as output of various backslash commands that query the database (such as \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e); but not error messages.\u003c/p\u003e\n\u003cdiv class=\"tip\"\u003e\n\u003ch3 class=\"title\"\u003eTip\u003c/h3\u003e\n\u003cp\u003eTo intersperse text output in between query results, use \u003ccode class=\"command\"\u003e\\qecho\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-OUT","modifiers":[],"related":[{"label":"\\o","url":"/wiki/psql/cmd-6f/?v=18"},{"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":"\\o or \\out [ filename ] \\o or \\out [ | command ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-OUT","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-OUT"}],"spellings":["\\o","\\out"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\o","url":"/wiki/psql/cmd-6f/?v=18"},"modifiers":"None listed in this signature"},{"command":{"text":"\\out","url":"/wiki/psql/cmd-6f-75-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-OUT","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-OUT","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-OUT"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-6f-75-74","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\out","Summary":"Arranges to save future query results to the file filename or pipe future results to the shell command command . If no argument is specified, the query output is reset to the standard output.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-OUT\"\u003e\u003cspan\u003e\u003ccode\u003e\\o\u003c/code\u003e or \u003ccode\u003e\\out [ \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003cbr\u003e\u003c/span\u003e\u003cspan\u003e\u003ccode\u003e\\o\u003c/code\u003e or \u003ccode\u003e\\out [ |\u003cem\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eArranges to save future query results to the file \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipe future results to the shell command \u003cem\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e. If no argument is specified, the query output is reset to the standard output.\u003c/p\u003e\n\u003cp\u003eIf the argument begins with \u003ccode\u003e|\u003c/code\u003e, then the entire remainder of the line is taken to be the \u003cem\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e to execute, and neither variable interpolation nor backquote expansion are performed in it. The rest of the line is simply passed literally to the shell.\u003c/p\u003e\n\u003cp\u003e\u003cspan\u003e“\u003cspan\u003eQuery results\u003c/span\u003e”\u003c/span\u003e includes all tables, command responses, and notices obtained from the database server, as well as output of various backslash commands that query the database (such as \u003ccode\u003e\\d\u003c/code\u003e); but not error messages.\u003c/p\u003e\n\u003cdiv\u003e\n\u003ch3\u003eTip\u003c/h3\u003e\n\u003cp\u003eTo intersperse text output in between query results, use \u003ccode\u003e\\qecho\u003c/code\u003e.\u003c/p\u003e\n\u003c/div\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"a0afce4b39e30da897330a91f8ec86ae0c3285b4eb2b35746f53a1aa88a03160","Payload":{"description":["Arranges to save future query results to the file filename or pipe future results to the shell command command . If no argument is specified, the query output is reset to the standard output."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-OUT\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\o\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\out [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\o\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\out [ |\u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eArranges to save future query results to the file \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipe future results to the shell command \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e. If no argument is specified, the query output is reset to the standard output.\u003c/p\u003e\n\u003cp\u003eIf the argument begins with \u003ccode class=\"literal\"\u003e|\u003c/code\u003e, then the entire remainder of the line is taken to be the \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e to execute, and neither variable interpolation nor backquote expansion are performed in it. The rest of the line is simply passed literally to the shell.\u003c/p\u003e\n\u003cp\u003e\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eQuery results\u003c/span\u003e”\u003c/span\u003e includes all tables, command responses, and notices obtained from the database server, as well as output of various backslash commands that query the database (such as \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e); but not error messages.\u003c/p\u003e\n\u003cdiv class=\"tip\"\u003e\n\u003ch3 class=\"title\"\u003eTip\u003c/h3\u003e\n\u003cp\u003eTo intersperse text output in between query results, use \u003ccode class=\"command\"\u003e\\qecho\u003c/code\u003e.\u003c/p\u003e\n\u003c/div\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"\\o","url":"/wiki/psql/cmd-6f/?v=18"},{"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":"\\o","url":"/wiki/psql/cmd-6f/?v=18"},"modifiers":"None listed in this signature"},{"command":{"text":"\\out","url":"/wiki/psql/cmd-6f-75-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":"\\o","Signature":"\\o or \\out [ filename ] \\o or \\out [ | command ]","Modifiers":[]},{"Version":"18","Ordinal":1,"Command":"\\out","Signature":"\\o or \\out [ filename ] \\o or \\out [ | command ]","Modifiers":[]}],"SQLState":null,"Evidence":null}