{"Entry":{"collection":"psql","key":"cmd-64-4f","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":"e6bd60776038c57f35e3d4f8edf866b9c5229e411bdec06f21c16afbf1362bdb","imported_at":"2026-09-30T00:40:44.814026+08:00","name":"\\dO","name_zh":"","slug":"cmd-64-4f","summary":"Lists collations. If pattern is specified, only collations whose names match the pattern are listed. 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, each collation is listed with its associated description, if any. Note that only collations usable with the current database's encoding are shown, so the results may vary in different databases of the same installation."}},"Definition":{"Collection":"psql","Key":"cmd-64-4f","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64-4f","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","Facts":{"command":"\\dO","comparison_data":{"definition":"Lists collations. If pattern is specified, only collations whose names match the pattern are listed. 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, each collation is listed with its associated description, if any. Note that only collations usable with the current database's encoding are shown, so the results may vary in different databases of the same installation.","modifiers":[{"command":"\\dO","modifiers":"Sx+"}],"signature":"\\dO[Sx+] [ pattern ]","spellings":["\\dO"]},"comparison_hash":"7ffee9384db69fa704dfc81f86e9d4367d1b22c4ec0fdf9c1f947556144ee766","description":["Lists collations. If pattern is specified, only collations whose names match the pattern are listed. 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, each collation is listed with its associated description, if any. Note that only collations usable with the current database's encoding are shown, so the results may vary in different databases of the same installation."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\dO"}],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DO-UC\"\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 ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eLists collations. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only collations whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e modifier to include system objects. If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name, each collation is listed with its associated description, if any. Note that only collations usable with the current database's encoding are shown, so the results may vary in different databases of the same installation.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DO-UC","modifiers":[{"command":"\\dO","modifiers":"Sx+"}],"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":"\\dO[Sx+] [ pattern ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DO-UC","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DO-UC"}],"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-4f/?v=18"},"modifiers":"Sx+"}],"title":"Spellings in this manual definition"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DO-UC","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-DO-UC","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DO-UC"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64-4f","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\dO","Summary":"Lists collations. If pattern is specified, only collations whose names match the pattern are listed. 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, each collation is listed with its associated description, if any. Note that only collations usable with the current database's encoding are shown, so the results may vary in different databases of the same installation.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DO-UC\"\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 ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eLists collations. If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only collations whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the \u003ccode\u003eS\u003c/code\u003e modifier to include system objects. If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode\u003e+\u003c/code\u003e is appended to the command name, each collation is listed with its associated description, if any. Note that only collations usable with the current database\u0026#39;s encoding are shown, so the results may vary in different databases of the same installation.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"3e58050627ebb15d04d1fc723f0e0497ebd230d158e02f77f1c43897f38ec042","Payload":{"description":["Lists collations. If pattern is specified, only collations whose names match the pattern are listed. 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, each collation is listed with its associated description, if any. Note that only collations usable with the current database's encoding are shown, so the results may vary in different databases of the same installation."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DO-UC\"\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 ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eLists collations. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only collations whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e modifier to include system objects. If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name, each collation is listed with its associated description, if any. Note that only collations usable with the current database's encoding are shown, so the results may vary in different databases of the same installation.\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":"\\dO","url":"/wiki/psql/cmd-64-4f/?v=18"},"modifiers":"Sx+"}],"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":"\\dO","Signature":"\\dO[Sx+] [ pattern ]","Modifiers":[{"command":"\\dO","modifiers":"Sx+"}]}],"SQLState":null,"Evidence":null}