{"Entry":{"collection":"psql","key":"cmd-64-6f","name":"\\do","aliases":["\\do","\\do+","\\doS","\\doS+","\\doSx","\\doSx+","\\dox","\\dox+"],"metadata":{"aliases":["\\do","\\do+","\\doS","\\doS+","\\doSx","\\doSx+","\\dox","\\dox+"],"category":"Describe database objects","content_hash":"b34052c4956af84424f4720c143dd4e2c38e8d962195c864aa0ed9ae8b3cbebd","derived_content_hash":"6fe0cfe8ae5efe71b3df64fef0ecf3d8fc6823524a3872befeb5210ddc3f19d4","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:44.920482+08:00","name":"\\do","name_zh":"","slug":"cmd-64-6f","summary":"Lists operators with their operand and result types. If pattern is specified, only operators whose names match the pattern are listed. If one arg_pattern is specified, only prefix operators whose right argument's type name matches that pattern are listed. If two arg_pattern s are specified, only binary operators whose argument type names match those patterns are listed. (Alternatively, write - for the unused argument of a unary operator.) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each operator is shown, including the name of the underlying function, and whether it is leakproof."}},"Definition":{"Collection":"psql","Key":"cmd-64-6f","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64-6f","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\do","comparison_data":{"definition":"Lists operators with their operand and result types. If pattern is specified, only operators whose names match the pattern are listed. If one arg_pattern is specified, only prefix operators whose right argument's type name matches that pattern are listed. If two arg_pattern s are specified, only binary operators whose argument type names match those patterns are listed. (Alternatively, write - for the unused argument of a unary operator.) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each operator is shown, including the name of the underlying function, and whether it is leakproof.","modifiers":[{"command":"\\do","modifiers":"Sx+"}],"signature":"\\do[Sx+] [ pattern [ arg_pattern [ arg_pattern ] ] ]","spellings":["\\do"]},"comparison_hash":"58ffd859e0d67023f73842d48a2679ce6ecf304c7072d36fc87f8fd3a1b930f3","description":["Lists operators with their operand and result types. If pattern is specified, only operators whose names match the pattern are listed. If one arg_pattern is specified, only prefix operators whose right argument's type name matches that pattern are listed. If two arg_pattern s are specified, only binary operators whose argument type names match those patterns are listed. (Alternatively, write - for the unused argument of a unary operator.) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each operator is shown, including the name of the underlying function, and whether it is leakproof."],"description_zh":"列出操作符及其操作数类型和结果类型。如果指定了 pattern ，则只列出名称与模式匹配的操作符。如果指定了一个 arg_pattern ，则只列出其右参数类型名称与该模式匹配的前缀操作符。如果指定了两个 arg_pattern ，则只列出参数类型名称与这些模式匹配的二元操作符。（对于一元操作符未使用的参数，也可以写成 - 。）默认情况下，只显示用户创建的对象；提供模式或 S 修饰符可包括系统对象。如果在命令名后追加 x ，结果会以扩展模式显示。如果在命令名后追加 + ，则会显示每个操作符的附加信息，包括底层函数名以及它是否防漏。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        列出操作符及其操作数类型和结果类型。如果指定了 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e，则只列出名称与模式匹配的操作符。如果指定了一个 \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e，则只列出其右参数类型名称与该模式匹配的前缀操作符。如果指定了两个 \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e，则只列出参数类型名称与这些模式匹配的二元操作符。（对于一元操作符未使用的参数，也可以写成 \u003ccode class=\"literal\"\u003e-\u003c/code\u003e。）默认情况下，只显示用户创建的对象；提供模式或 \u003ccode class=\"literal\"\u003eS\u003c/code\u003e 修饰符可包括系统对象。如果在命令名后追加 \u003ccode class=\"literal\"\u003ex\u003c/code\u003e，结果会以扩展模式显示。如果在命令名后追加 \u003ccode class=\"literal\"\u003e+\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":"\\do"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\do"}],"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-DO-LC\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\do[Sx+] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e ] ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists operators with their operand and result types.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only operators whose names match the pattern are listed.\n        If one \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only prefix operators whose right argument's type name\n        matches that pattern are listed.\n        If two \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003es\n        are specified, only binary operators whose argument type names match\n        those patterns are listed.  (Alternatively, write \u003ccode class=\"literal\"\u003e-\u003c/code\u003e\n        for the unused argument of a unary operator.)\n        By default, only user-created objects are shown; supply a\n        pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e modifier to include system\n        objects.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name,\n        additional information about each operator is shown, including\n        the name of the underlying function, and whether it is leakproof.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DO-LC","modifiers":[{"command":"\\do","modifiers":"Sx+"}],"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":"\\do[Sx+] [ pattern [ arg_pattern [ arg_pattern ] ] ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DO-LC","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DO-LC"}],"spellings":["\\do"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\do","url":"/wiki/psql/cmd-64-6f/?v=18"},"modifiers":"Sx+"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\do","url":"/wiki/psql/cmd-64-6f/?v=18"},"modifiers":"Sx+"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DO-LC","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-DO-LC","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DO-LC"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64-6f","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\do","Summary":"Lists operators with their operand and result types. If pattern is specified, only operators whose names match the pattern are listed. If one arg_pattern is specified, only prefix operators whose right argument's type name matches that pattern are listed. If two arg_pattern s are specified, only binary operators whose argument type names match those patterns are listed. (Alternatively, write - for the unused argument of a unary operator.) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each operator is shown, including the name of the underlying function, and whether it is leakproof.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DO-LC\"\u003e\u003cspan\u003e\u003ccode\u003e\\do[Sx+] [ \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\" rel=\"nofollow\"\u003e\u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003cem\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e [ \u003cem\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e ] ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists operators with their operand and result types.\n        If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only operators whose names match the pattern are listed.\n        If one \u003cem\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only prefix operators whose right argument\u0026#39;s type name\n        matches that pattern are listed.\n        If two \u003cem\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003es\n        are specified, only binary operators whose argument type names match\n        those patterns are listed.  (Alternatively, write \u003ccode\u003e-\u003c/code\u003e\n        for the unused argument of a unary operator.)\n        By default, only user-created objects are shown; supply a\n        pattern or the \u003ccode\u003eS\u003c/code\u003e modifier to include system\n        objects.\n        If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode\u003e+\u003c/code\u003e is appended to the command name,\n        additional information about each operator is shown, including\n        the name of the underlying function, and whether it is leakproof.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"7cc03534831f406026556b49602e9d97cced996f01b86a51fb63ac474373cdb7","Payload":{"description":["Lists operators with their operand and result types. If pattern is specified, only operators whose names match the pattern are listed. If one arg_pattern is specified, only prefix operators whose right argument's type name matches that pattern are listed. If two arg_pattern s are specified, only binary operators whose argument type names match those patterns are listed. (Alternatively, write - for the unused argument of a unary operator.) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each operator is shown, including the name of the underlying function, and whether it is leakproof."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DO-LC\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\do[Sx+] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e ] ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists operators with their operand and result types.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only operators whose names match the pattern are listed.\n        If one \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only prefix operators whose right argument's type name\n        matches that pattern are listed.\n        If two \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003es\n        are specified, only binary operators whose argument type names match\n        those patterns are listed.  (Alternatively, write \u003ccode class=\"literal\"\u003e-\u003c/code\u003e\n        for the unused argument of a unary operator.)\n        By default, only user-created objects are shown; supply a\n        pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e modifier to include system\n        objects.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name,\n        additional information about each operator is shown, including\n        the name of the underlying function, and whether it is leakproof.\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":"\\do","url":"/wiki/psql/cmd-64-6f/?v=18"},"modifiers":"Sx+"}],"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":"\\do","Signature":"\\do[Sx+] [ pattern [ arg_pattern [ arg_pattern ] ] ]","Modifiers":[{"command":"\\do","modifiers":"Sx+"}]}],"SQLState":null,"Evidence":null}