{"Entry":{"collection":"psql","key":"cmd-6f","name":"\\o","aliases":["\\o"],"metadata":{"aliases":["\\o"],"category":"Output and formatting","content_hash":"f58205ddf0a22908ea532daea856f47b942a7e315a966a5c874c8df1265cbf99","derived_content_hash":"3e56e08746b0b8ae79d90a54c5d78d864fde14213340412b0b54438104b3ef50","documentation_refresh":{"batch":"20261113","original_source_rev":"","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"imported_at":"2026-09-30T00:40:45.114791+08:00","name":"\\o","name_zh":"","slug":"cmd-6f","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","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-6f","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\o","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."],"description_zh":"将后续查询结果保存到文件 filename ，或通过管道传给 shell 命令 command 。如果没有指定参数，查询输出将恢复为标准输出。","description_zh_html":"\u003cdd\u003e\u003cp\u003e将后续查询结果保存到文件 \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e，或通过管道传给 shell 命令 \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e。如果没有指定参数，查询输出将恢复为标准输出。\u003c/p\u003e\u003cp\u003e如果参数以\u003ccode class=\"literal\"\u003e|\u003c/code\u003e开头，则该行剩余的全部内容会被视为要执行的 \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e，其中不会进行变量插值或反引号扩展。该行剩余的内容只会原样传递给 shell。\u003c/p\u003e\u003cp\u003e\n\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e查询结果\u003c/span\u003e”\u003c/span\u003e包括从数据库服务器获取的所有表格、命令响应和通知，以及查询数据库的各种反斜杠命令的输出（例如\u003ccode class=\"command\"\u003e\\d\u003c/code\u003e）；但不包括错误消息。\n        \u003c/p\u003e\u003cdiv class=\"tip\"\u003e\u003ch3 class=\"title\"\u003e提示\u003c/h3\u003e\u003cp\u003e\n        要在查询结果之间插入文本输出，使用\u003ccode class=\"command\"\u003e\\qecho\u003c/code\u003e。\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e","documentation_revision":{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"facts":[{"label":"Client","value":"psql 18.7"},{"label":"Case-sensitive spelling","value":"\\o"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\o"}],"localization":{"documentation_release":"18.7","language":"en","source_language":"en","source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552","status":"same-version-reviewed-manual"},"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\u003cp\u003e\n        Arranges to save future query results to the file \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipe future results\n        to the shell command \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e. If no argument is\n        specified, the query output is reset to the standard output.\n        \u003c/p\u003e\u003cp\u003e\n        If the argument begins with \u003ccode class=\"literal\"\u003e|\u003c/code\u003e, then the entire remainder\n        of the line is taken to be\n        the \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e to execute,\n        and neither variable interpolation nor backquote expansion are\n        performed in it.  The rest of the line is simply passed literally to\n        the shell.\n        \u003c/p\u003e\u003cp\u003e\n\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eQuery results\u003c/span\u003e”\u003c/span\u003e includes all tables, command\n        responses, and notices obtained from the database server, as\n        well as output of various backslash commands that query the\n        database (such as \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e); but not error\n        messages.\n        \u003c/p\u003e\u003cdiv class=\"tip\"\u003e\u003ch3 class=\"title\"\u003eTip\u003c/h3\u003e\u003cp\u003e\n        To intersperse text output in between query results, use\n        \u003ccode class=\"command\"\u003e\\qecho\u003c/code\u003e.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-OUT","modifiers":[],"related":[{"label":"\\out","url":"/wiki/psql/cmd-6f-75-74/?v=18"},{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"\\out","url":"/wiki/psql/cmd-6f-75-74/?v=18"},{"label":"psql 命令行选项及完整手册","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sections":[],"sections_zh":[],"signature":"\\o or \\out [ filename ] \\o or \\out [ | command ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-OUT","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","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"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\o","url":"/wiki/psql/cmd-6f/?v=18"},"modifiers":"此语法签名未列出"},{"command":{"text":"\\out","url":"/wiki/psql/cmd-6f-75-74/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-OUT","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-OUT","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-OUT"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-6f","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\o","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\u003cp\u003e\n        Arranges to save future query results to the file \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipe future results\n        to the shell command \u003cem\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e. If no argument is\n        specified, the query output is reset to the standard output.\n        \u003c/p\u003e\u003cp\u003e\n        If the argument begins with \u003ccode\u003e|\u003c/code\u003e, then the entire remainder\n        of the line is taken to be\n        the \u003cem\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e to execute,\n        and neither variable interpolation nor backquote expansion are\n        performed in it.  The rest of the line is simply passed literally to\n        the shell.\n        \u003c/p\u003e\u003cp\u003e\n\u003cspan\u003e“\u003cspan\u003eQuery results\u003c/span\u003e”\u003c/span\u003e includes all tables, command\n        responses, and notices obtained from the database server, as\n        well as output of various backslash commands that query the\n        database (such as \u003ccode\u003e\\d\u003c/code\u003e); but not error\n        messages.\n        \u003c/p\u003e\u003cdiv\u003e\u003ch3\u003eTip\u003c/h3\u003e\u003cp\u003e\n        To intersperse text output in between query results, use\n        \u003ccode\u003e\\qecho\u003c/code\u003e.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"9e1a4734f30396372f4bff4d5f08ced6d244947150f4f89bb30b9779c9d2c3c2","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\u003cp\u003e\n        Arranges to save future query results to the file \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipe future results\n        to the shell command \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e. If no argument is\n        specified, the query output is reset to the standard output.\n        \u003c/p\u003e\u003cp\u003e\n        If the argument begins with \u003ccode class=\"literal\"\u003e|\u003c/code\u003e, then the entire remainder\n        of the line is taken to be\n        the \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e to execute,\n        and neither variable interpolation nor backquote expansion are\n        performed in it.  The rest of the line is simply passed literally to\n        the shell.\n        \u003c/p\u003e\u003cp\u003e\n\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eQuery results\u003c/span\u003e”\u003c/span\u003e includes all tables, command\n        responses, and notices obtained from the database server, as\n        well as output of various backslash commands that query the\n        database (such as \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e); but not error\n        messages.\n        \u003c/p\u003e\u003cdiv class=\"tip\"\u003e\u003ch3 class=\"title\"\u003eTip\u003c/h3\u003e\u003cp\u003e\n        To intersperse text output in between query results, use\n        \u003ccode class=\"command\"\u003e\\qecho\u003c/code\u003e.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"\\out","url":"/wiki/psql/cmd-6f-75-74/?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":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"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}