{"Entry":{"collection":"psql","key":"cmd-65-76","name":"\\ev","aliases":["\\ev"],"metadata":{"aliases":["\\ev"],"category":"Query buffer and editing","content_hash":"1423278aafcab9572af8558319aef0ca9057c65b8313f8e909e4dc924d6be531","derived_content_hash":"b8752211d431473e66b19895941c85fa54e0dce8b7fd0a484364d2b26eaf66ca","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.010011+08:00","name":"\\ev","name_zh":"","slug":"cmd-65-76","summary":"This command fetches and edits the definition of the named view, in the form of a CREATE OR REPLACE VIEW command. Editing is done in the same way as for \\edit . If you quit the editor without saving, the statement is discarded. If you save and exit the editor, the updated command is executed immediately if you added a semicolon to it. Otherwise it is redisplayed; type semicolon or \\g to send it, or \\r to cancel."}},"Definition":{"Collection":"psql","Key":"cmd-65-76","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-65-76","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\ev","comparison_data":{"definition":"This command fetches and edits the definition of the named view, in the form of a CREATE OR REPLACE VIEW command. Editing is done in the same way as for \\edit . If you quit the editor without saving, the statement is discarded. If you save and exit the editor, the updated command is executed immediately if you added a semicolon to it. Otherwise it is redisplayed; type semicolon or \\g to send it, or \\r to cancel. If no view is specified, a blank CREATE VIEW template is presented for editing. If a line number is specified, psql will position the cursor on the specified line of the view definition. Unlike most other meta-commands, the entire remainder of the line is always taken to be the argument(s) of \\ev , and neither variable interpolation nor backquote expansion are performed in the arguments.","modifiers":[],"signature":"\\ev [ view_name [ line_number ] ]","spellings":["\\ev"]},"comparison_hash":"01498eb75de2e82dde5a87892e4e5490f45c6a07af1386fb8ddea9983a4eb85b","description":["This command fetches and edits the definition of the named view, in the form of a CREATE OR REPLACE VIEW command. Editing is done in the same way as for \\edit . If you quit the editor without saving, the statement is discarded. If you save and exit the editor, the updated command is executed immediately if you added a semicolon to it. Otherwise it is redisplayed; type semicolon or \\g to send it, or \\r to cancel."],"description_zh":"这个命令获取并编辑指定视图的定义，形式为 CREATE OR REPLACE VIEW 命令。编辑方式与 \\edit 相同。如果在不保存的情况下退出编辑器，则该语句会被丢弃。如果保存并退出编辑器，并在其中添加了分号，则更新后的命令会立即执行；否则将重新显示；输入分号或 \\g 发送它，或用 \\r 取消。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n         这个命令获取并编辑指定视图的定义，形式为 \u003ccode class=\"command\"\u003eCREATE OR REPLACE VIEW\u003c/code\u003e 命令。编辑方式与\u003ccode class=\"literal\"\u003e\\edit\u003c/code\u003e 相同。如果在不保存的情况下退出编辑器，则该语句会被丢弃。如果保存并退出编辑器，并在其中添加了分号，则更新后的命令会立即执行；否则将重新显示；输入分号或\u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e 发送它，或用\u003ccode class=\"literal\"\u003e\\r\u003c/code\u003e 取消。\n        \u003c/p\u003e\u003cp\u003e\n         如果未指定视图，则会呈现一个空的 \u003ccode class=\"command\"\u003eCREATE VIEW\u003c/code\u003e 模板供编辑。\n        \u003c/p\u003e\u003cp\u003e\n         如果指定了行号，\u003cspan class=\"application\"\u003epsql\u003c/span\u003e 将光标定位在视图定义的指定行上。\n        \u003c/p\u003e\u003cp\u003e\n        与大多数其他元命令不同，整个行的剩余部分始终被视为\u003ccode class=\"command\"\u003e\\ev\u003c/code\u003e 的参数，参数中不进行变量插值或反引号扩展。\n        \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":"\\ev"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\ev"}],"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-EV\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\ev [\u003cspan class=\"optional\"\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eview_name\u003c/code\u003e\u003c/em\u003e [\u003cspan class=\"optional\"\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eline_number\u003c/code\u003e\u003c/em\u003e \u003c/span\u003e] \u003c/span\u003e] \u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n         This command fetches and edits the definition of the named view,\n         in the form of a \u003ccode class=\"command\"\u003eCREATE OR REPLACE VIEW\u003c/code\u003e command.\n         Editing is done in the same way as for \u003ccode class=\"literal\"\u003e\\edit\u003c/code\u003e.\n         If you quit the editor without saving, the statement is discarded.\n         If you save and exit the editor, the updated command is executed immediately\n         if you added a semicolon to it.  Otherwise it is redisplayed;\n         type semicolon or \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e to send it, or \u003ccode class=\"literal\"\u003e\\r\u003c/code\u003e\n         to cancel.\n        \u003c/p\u003e\u003cp\u003e\n         If no view is specified, a blank \u003ccode class=\"command\"\u003eCREATE VIEW\u003c/code\u003e\n         template is presented for editing.\n        \u003c/p\u003e\u003cp\u003e\n         If a line number is specified, \u003cspan class=\"application\"\u003epsql\u003c/span\u003e will\n         position the cursor on the specified line of the view definition.\n        \u003c/p\u003e\u003cp\u003e\n        Unlike most other meta-commands, the entire remainder of the line is\n        always taken to be the argument(s) of \u003ccode class=\"command\"\u003e\\ev\u003c/code\u003e, and neither\n        variable interpolation nor backquote expansion are performed in the\n        arguments.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-EV","modifiers":[],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"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":"\\ev [ view_name [ line_number ] ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-EV","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-EV"}],"spellings":["\\ev"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\ev","url":"/wiki/psql/cmd-65-76/?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":"\\ev","url":"/wiki/psql/cmd-65-76/?v=18"},"modifiers":"此语法签名未列出"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-EV","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-EV","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-EV"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-65-76","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\ev","Summary":"This command fetches and edits the definition of the named view, in the form of a CREATE OR REPLACE VIEW command. Editing is done in the same way as for \\edit . If you quit the editor without saving, the statement is discarded. If you save and exit the editor, the updated command is executed immediately if you added a semicolon to it. Otherwise it is redisplayed; type semicolon or \\g to send it, or \\r to cancel.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-EV\"\u003e\u003cspan\u003e\u003ccode\u003e\\ev [\u003cspan\u003e \u003cem\u003e\u003ccode\u003eview_name\u003c/code\u003e\u003c/em\u003e [\u003cspan\u003e \u003cem\u003e\u003ccode\u003eline_number\u003c/code\u003e\u003c/em\u003e \u003c/span\u003e] \u003c/span\u003e] \u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n         This command fetches and edits the definition of the named view,\n         in the form of a \u003ccode\u003eCREATE OR REPLACE VIEW\u003c/code\u003e command.\n         Editing is done in the same way as for \u003ccode\u003e\\edit\u003c/code\u003e.\n         If you quit the editor without saving, the statement is discarded.\n         If you save and exit the editor, the updated command is executed immediately\n         if you added a semicolon to it.  Otherwise it is redisplayed;\n         type semicolon or \u003ccode\u003e\\g\u003c/code\u003e to send it, or \u003ccode\u003e\\r\u003c/code\u003e\n         to cancel.\n        \u003c/p\u003e\u003cp\u003e\n         If no view is specified, a blank \u003ccode\u003eCREATE VIEW\u003c/code\u003e\n         template is presented for editing.\n        \u003c/p\u003e\u003cp\u003e\n         If a line number is specified, \u003cspan\u003epsql\u003c/span\u003e will\n         position the cursor on the specified line of the view definition.\n        \u003c/p\u003e\u003cp\u003e\n        Unlike most other meta-commands, the entire remainder of the line is\n        always taken to be the argument(s) of \u003ccode\u003e\\ev\u003c/code\u003e, and neither\n        variable interpolation nor backquote expansion are performed in the\n        arguments.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"de4964b0abe248f4f59995f01be6d713b700964a7e373396fd7d52e8960e7fa8","Payload":{"description":["This command fetches and edits the definition of the named view, in the form of a CREATE OR REPLACE VIEW command. Editing is done in the same way as for \\edit . If you quit the editor without saving, the statement is discarded. If you save and exit the editor, the updated command is executed immediately if you added a semicolon to it. Otherwise it is redisplayed; type semicolon or \\g to send it, or \\r to cancel."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-EV\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\ev [\u003cspan class=\"optional\"\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eview_name\u003c/code\u003e\u003c/em\u003e [\u003cspan class=\"optional\"\u003e \u003cem class=\"replaceable\"\u003e\u003ccode\u003eline_number\u003c/code\u003e\u003c/em\u003e \u003c/span\u003e] \u003c/span\u003e] \u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n         This command fetches and edits the definition of the named view,\n         in the form of a \u003ccode class=\"command\"\u003eCREATE OR REPLACE VIEW\u003c/code\u003e command.\n         Editing is done in the same way as for \u003ccode class=\"literal\"\u003e\\edit\u003c/code\u003e.\n         If you quit the editor without saving, the statement is discarded.\n         If you save and exit the editor, the updated command is executed immediately\n         if you added a semicolon to it.  Otherwise it is redisplayed;\n         type semicolon or \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e to send it, or \u003ccode class=\"literal\"\u003e\\r\u003c/code\u003e\n         to cancel.\n        \u003c/p\u003e\u003cp\u003e\n         If no view is specified, a blank \u003ccode class=\"command\"\u003eCREATE VIEW\u003c/code\u003e\n         template is presented for editing.\n        \u003c/p\u003e\u003cp\u003e\n         If a line number is specified, \u003cspan class=\"application\"\u003epsql\u003c/span\u003e will\n         position the cursor on the specified line of the view definition.\n        \u003c/p\u003e\u003cp\u003e\n        Unlike most other meta-commands, the entire remainder of the line is\n        always taken to be the argument(s) of \u003ccode class=\"command\"\u003e\\ev\u003c/code\u003e, and neither\n        variable interpolation nor backquote expansion are performed in the\n        arguments.\n        \u003c/p\u003e\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":"\\ev","url":"/wiki/psql/cmd-65-76/?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":"\\ev","Signature":"\\ev [ view_name [ line_number ] ]","Modifiers":[]}],"SQLState":null,"Evidence":null}