{"Entry":{"collection":"psql","key":"cmd-77","name":"\\w","aliases":["\\w"],"metadata":{"aliases":["\\w"],"category":"Query buffer and editing","content_hash":"f7c9e584255f744919811af9bba49f5c17f829acac036d23b30e3c3fb0168b0f","derived_content_hash":"003b216b209276394099099a9d0403959e33830eceb6ffc814c632ee60bc3e13","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.224713+08:00","name":"\\w","name_zh":"","slug":"cmd-77","summary":"Writes the current query buffer to the file filename or pipes it to the shell command command . If the current query buffer is empty, the most recently executed query is written instead."}},"Definition":{"Collection":"psql","Key":"cmd-77","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-77","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\w","comparison_data":{"definition":"Writes the current query buffer to the file filename or pipes it to the shell command command . If the current query buffer is empty, the most recently executed query is written instead. 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.","modifiers":[],"signature":"\\w or \\write filename \\w or \\write | command","spellings":["\\w","\\write"]},"comparison_hash":"106cb9699bda40a3fc474a756041e9829c9d39dd106f8791ec7271e8749a1587","description":["Writes the current query buffer to the file filename or pipes it to the shell command command . If the current query buffer is empty, the most recently executed query is written instead."],"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\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":"\\w"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\w"}],"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-WRITE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\w\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\write\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\w\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\write\u003c/code\u003e \u003ccode class=\"literal\"\u003e|\u003c/code\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Writes the current query buffer to the file \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipes it to the shell\n        command \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e.\n        If the current query buffer is empty, the most recently executed query\n        is written instead.\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\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-WRITE","modifiers":[],"related":[{"label":"\\write","url":"/wiki/psql/cmd-77-72-69-74-65/?v=18"},{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"\\write","url":"/wiki/psql/cmd-77-72-69-74-65/?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":"\\w or \\write filename \\w or \\write | command","sources":[{"anchor":"APP-PSQL-META-COMMAND-WRITE","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-WRITE"}],"spellings":["\\w","\\write"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\w","url":"/wiki/psql/cmd-77/?v=18"},"modifiers":"None listed in this signature"},{"command":{"text":"\\write","url":"/wiki/psql/cmd-77-72-69-74-65/?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":"\\w","url":"/wiki/psql/cmd-77/?v=18"},"modifiers":"此语法签名未列出"},{"command":{"text":"\\write","url":"/wiki/psql/cmd-77-72-69-74-65/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-WRITE","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-WRITE","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-WRITE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-77","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\w","Summary":"Writes the current query buffer to the file filename or pipes it to the shell command command . If the current query buffer is empty, the most recently executed query is written instead.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-WRITE\"\u003e\u003cspan\u003e\u003ccode\u003e\\w\u003c/code\u003e or \u003ccode\u003e\\write\u003c/code\u003e \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003cbr\u003e\u003c/span\u003e\u003cspan\u003e\u003ccode\u003e\\w\u003c/code\u003e or \u003ccode\u003e\\write\u003c/code\u003e \u003ccode\u003e|\u003c/code\u003e\u003cem\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Writes the current query buffer to the file \u003cem\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipes it to the shell\n        command \u003cem\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e.\n        If the current query buffer is empty, the most recently executed query\n        is written instead.\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\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"526d3ee1eaa6ef449aba4dc1b39a125dd72958a06709eb075c37521787eb5944","Payload":{"description":["Writes the current query buffer to the file filename or pipes it to the shell command command . If the current query buffer is empty, the most recently executed query is written instead."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-WRITE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\w\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\write\u003c/code\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\w\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\write\u003c/code\u003e \u003ccode class=\"literal\"\u003e|\u003c/code\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Writes the current query buffer to the file \u003cem class=\"replaceable\"\u003e\u003ccode\u003efilename\u003c/code\u003e\u003c/em\u003e or pipes it to the shell\n        command \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecommand\u003c/code\u003e\u003c/em\u003e.\n        If the current query buffer is empty, the most recently executed query\n        is written instead.\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\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"\\write","url":"/wiki/psql/cmd-77-72-69-74-65/?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":"\\w","url":"/wiki/psql/cmd-77/?v=18"},"modifiers":"None listed in this signature"},{"command":{"text":"\\write","url":"/wiki/psql/cmd-77-72-69-74-65/?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":"\\w","Signature":"\\w or \\write filename \\w or \\write | command","Modifiers":[]},{"Version":"18","Ordinal":1,"Command":"\\write","Signature":"\\w or \\write filename \\w or \\write | command","Modifiers":[]}],"SQLState":null,"Evidence":null}