{"Entry":{"collection":"psql","key":"cmd-64-64","name":"\\dd","aliases":["\\dd","\\ddS","\\ddSx","\\ddx"],"metadata":{"aliases":["\\dd","\\ddS","\\ddSx","\\ddx"],"category":"Describe database objects","content_hash":"1fc6b6a9f660305e965230bd0006ec171526fc940a0c79a05bcfb084ead7c9ce","imported_at":"2026-09-30T00:40:44.857442+08:00","name":"\\dd","name_zh":"","slug":"cmd-64-64","summary":"Shows the descriptions of objects of type constraint , operator class , operator family , rule , and trigger . All other comments may be viewed by the respective backslash commands for those object types."}},"Definition":{"Collection":"psql","Key":"cmd-64-64","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64-64","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","Facts":{"command":"\\dd","comparison_data":{"definition":"Shows the descriptions of objects of type constraint , operator class , operator family , rule , and trigger . All other comments may be viewed by the respective backslash commands for those object types. \\dd displays descriptions for objects matching the pattern , or of visible objects of the appropriate type if no argument is given. But in either case, only objects that have a description 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. Descriptions for objects can be created with the COMMENT SQL command.","modifiers":[{"command":"\\dd","modifiers":"Sx"}],"signature":"\\dd[Sx] [ pattern ]","spellings":["\\dd"]},"comparison_hash":"f245b16c02d98a66694299aae5f9fa01b4a055b69c46d42b9ae85411be476798","description":["Shows the descriptions of objects of type constraint , operator class , operator family , rule , and trigger . All other comments may be viewed by the respective backslash commands for those object types."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\dd"}],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DD-LC\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dd[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\u003eShows the descriptions of objects of type \u003ccode class=\"literal\"\u003econstraint\u003c/code\u003e, \u003ccode class=\"literal\"\u003eoperator class\u003c/code\u003e, \u003ccode class=\"literal\"\u003eoperator family\u003c/code\u003e, \u003ccode class=\"literal\"\u003erule\u003c/code\u003e, and \u003ccode class=\"literal\"\u003etrigger\u003c/code\u003e. All other comments may be viewed by the respective backslash commands for those object types.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003e\\dd\u003c/code\u003e displays descriptions for objects matching the \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e, or of visible objects of the appropriate type if no argument is given. But in either case, only objects that have a description 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.\u003c/p\u003e\n\u003cp\u003eDescriptions for objects can be created with the \u003ca class=\"link\" href=\"/docs/18/sql-comment.html\" title=\"COMMENT\"\u003e\u003ccode class=\"command\"\u003eCOMMENT\u003c/code\u003e\u003c/a\u003e SQL command.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DD-LC","modifiers":[{"command":"\\dd","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":"\\dd[Sx] [ pattern ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DD-LC","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DD-LC"}],"spellings":["\\dd"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\dd","url":"/wiki/psql/cmd-64-64/?v=18"},"modifiers":"Sx"}],"title":"Spellings in this manual definition"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DD-LC","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-DD-LC","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DD-LC"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64-64","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\dd","Summary":"Shows the descriptions of objects of type constraint , operator class , operator family , rule , and trigger . All other comments may be viewed by the respective backslash commands for those object types.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DD-LC\"\u003e\u003cspan\u003e\u003ccode\u003e\\dd[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\u003eShows the descriptions of objects of type \u003ccode\u003econstraint\u003c/code\u003e, \u003ccode\u003eoperator class\u003c/code\u003e, \u003ccode\u003eoperator family\u003c/code\u003e, \u003ccode\u003erule\u003c/code\u003e, and \u003ccode\u003etrigger\u003c/code\u003e. All other comments may be viewed by the respective backslash commands for those object types.\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003e\\dd\u003c/code\u003e displays descriptions for objects matching the \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e, or of visible objects of the appropriate type if no argument is given. But in either case, only objects that have a description 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.\u003c/p\u003e\n\u003cp\u003eDescriptions for objects can be created with the \u003ca href=\"/docs/18/sql-comment.html\" title=\"COMMENT\" rel=\"nofollow\"\u003e\u003ccode\u003eCOMMENT\u003c/code\u003e\u003c/a\u003e SQL command.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"756e7f677c15dbd544fda23689a728829dc5289747e9df347fb5681d07aff1ec","Payload":{"description":["Shows the descriptions of objects of type constraint , operator class , operator family , rule , and trigger . All other comments may be viewed by the respective backslash commands for those object types."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DD-LC\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dd[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\u003eShows the descriptions of objects of type \u003ccode class=\"literal\"\u003econstraint\u003c/code\u003e, \u003ccode class=\"literal\"\u003eoperator class\u003c/code\u003e, \u003ccode class=\"literal\"\u003eoperator family\u003c/code\u003e, \u003ccode class=\"literal\"\u003erule\u003c/code\u003e, and \u003ccode class=\"literal\"\u003etrigger\u003c/code\u003e. All other comments may be viewed by the respective backslash commands for those object types.\u003c/p\u003e\n\u003cp\u003e\u003ccode class=\"literal\"\u003e\\dd\u003c/code\u003e displays descriptions for objects matching the \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e, or of visible objects of the appropriate type if no argument is given. But in either case, only objects that have a description 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.\u003c/p\u003e\n\u003cp\u003eDescriptions for objects can be created with the \u003ca class=\"link\" href=\"/docs/18/sql-comment.html\" title=\"COMMENT\"\u003e\u003ccode class=\"command\"\u003eCOMMENT\u003c/code\u003e\u003c/a\u003e SQL command.\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":"\\dd","url":"/wiki/psql/cmd-64-64/?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":"\\dd","Signature":"\\dd[Sx] [ pattern ]","Modifiers":[{"command":"\\dd","modifiers":"Sx"}]}],"SQLState":null,"Evidence":null}