{"Entry":{"collection":"psql","key":"cmd-65-76","name":"\\ev","aliases":["\\ev"],"metadata":{"aliases":["\\ev"],"category":"Query buffer and editing","content_hash":"1423278aafcab9572af8558319aef0ca9057c65b8313f8e909e4dc924d6be531","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":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","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."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\ev"}],"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\n\u003cp\u003eThis command fetches and edits the definition of the named view, in the form of a \u003ccode class=\"command\"\u003eCREATE OR REPLACE VIEW\u003c/code\u003e command. Editing is done in the same way as for \u003ccode class=\"literal\"\u003e\\edit\u003c/code\u003e. 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 \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e to send it, or \u003ccode class=\"literal\"\u003e\\r\u003c/code\u003e to cancel.\u003c/p\u003e\n\u003cp\u003eIf no view is specified, a blank \u003ccode class=\"command\"\u003eCREATE VIEW\u003c/code\u003e template is presented for editing.\u003c/p\u003e\n\u003cp\u003eIf a line number is specified, \u003cspan class=\"application\"\u003epsql\u003c/span\u003e will position the cursor on the specified line of the view definition.\u003c/p\u003e\n\u003cp\u003eUnlike most other meta-commands, the entire remainder of the line is always taken to be the argument(s) of \u003ccode class=\"command\"\u003e\\ev\u003c/code\u003e, and neither variable interpolation nor backquote expansion are performed in the arguments.\u003c/p\u003e\n\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"}],"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":"\\ev [ view_name [ line_number ] ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-EV","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","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"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-EV","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-EV","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","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\n\u003cp\u003eThis command fetches and edits the definition of the named view, in the form of a \u003ccode\u003eCREATE OR REPLACE VIEW\u003c/code\u003e command. Editing is done in the same way as for \u003ccode\u003e\\edit\u003c/code\u003e. 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 \u003ccode\u003e\\g\u003c/code\u003e to send it, or \u003ccode\u003e\\r\u003c/code\u003e to cancel.\u003c/p\u003e\n\u003cp\u003eIf no view is specified, a blank \u003ccode\u003eCREATE VIEW\u003c/code\u003e template is presented for editing.\u003c/p\u003e\n\u003cp\u003eIf a line number is specified, \u003cspan\u003epsql\u003c/span\u003e will position the cursor on the specified line of the view definition.\u003c/p\u003e\n\u003cp\u003eUnlike most other meta-commands, the entire remainder of the line is always taken to be the argument(s) of \u003ccode\u003e\\ev\u003c/code\u003e, and neither variable interpolation nor backquote expansion are performed in the arguments.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"6148bc64be161c004a83b0cbe66db5c46b7921ebf893d704a17680db7e414eb7","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\n\u003cp\u003eThis command fetches and edits the definition of the named view, in the form of a \u003ccode class=\"command\"\u003eCREATE OR REPLACE VIEW\u003c/code\u003e command. Editing is done in the same way as for \u003ccode class=\"literal\"\u003e\\edit\u003c/code\u003e. 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 \u003ccode class=\"literal\"\u003e\\g\u003c/code\u003e to send it, or \u003ccode class=\"literal\"\u003e\\r\u003c/code\u003e to cancel.\u003c/p\u003e\n\u003cp\u003eIf no view is specified, a blank \u003ccode class=\"command\"\u003eCREATE VIEW\u003c/code\u003e template is presented for editing.\u003c/p\u003e\n\u003cp\u003eIf a line number is specified, \u003cspan class=\"application\"\u003epsql\u003c/span\u003e will position the cursor on the specified line of the view definition.\u003c/p\u003e\n\u003cp\u003eUnlike most other meta-commands, the entire remainder of the line is always taken to be the argument(s) of \u003ccode class=\"command\"\u003e\\ev\u003c/code\u003e, and neither variable interpolation nor backquote expansion are performed in the arguments.\u003c/p\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":"\\ev","url":"/wiki/psql/cmd-65-76/?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":"\\ev","Signature":"\\ev [ view_name [ line_number ] ]","Modifiers":[]}],"SQLState":null,"Evidence":null}