{"Entry":{"collection":"psql","key":"cmd-64-64-70","name":"\\ddp","aliases":["\\ddp","\\ddpx"],"metadata":{"aliases":["\\ddp","\\ddpx"],"category":"Describe database objects","content_hash":"64b9ad6d5887bd0f118f6e60c8829dbf389bf427167660ed3d594eca29209a5d","derived_content_hash":"82520b04462774a743fd8369df6affcdca291b8ebcc864cadfb1aef65cdd85a4","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.863188+08:00","name":"\\ddp","name_zh":"","slug":"cmd-64-64-70","summary":"Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or schema name matches the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode."}},"Definition":{"Collection":"psql","Key":"cmd-64-64-70","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64-64-70","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\ddp","comparison_data":{"definition":"Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or schema name matches the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. The ALTER DEFAULT PRIVILEGES command is used to set default access privileges. The meaning of the privilege display is explained in Section 5.8 .","modifiers":[{"command":"\\ddp","modifiers":"x"}],"signature":"\\ddp[x] [ pattern ]","spellings":["\\ddp"]},"comparison_hash":"d649a297a7c2136ebc9489d43861098bf2daa3b4df6264ad94857be542fb4844","description":["Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or schema name matches the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode."],"description_zh":"列出默认访问权限设置。对于每个默认权限设置已偏离内置默认值的角色（以及适用时的模式），都会显示一条记录。如果指定了 pattern ，则只列出角色名或模式名与模式匹配的记录。如果在命令名后追加 x ，结果会以扩展模式显示。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        列出默认访问权限设置。对于每个默认权限设置已偏离内置默认值的角色（以及适用时的模式），都会显示一条记录。如果指定了 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e，则只列出角色名或模式名与模式匹配的记录。如果在命令名后追加 \u003ccode class=\"literal\"\u003ex\u003c/code\u003e，结果会以扩展模式显示。\n        \u003c/p\u003e\u003cp\u003e\n\u003ca class=\"link\" href=\"/zh/docs/18/sql-alterdefaultprivileges.html\" title=\"ALTER DEFAULT PRIVILEGES\"\u003e\u003ccode class=\"command\"\u003eALTER DEFAULT\n        PRIVILEGES\u003c/code\u003e\u003c/a\u003e 命令用于设置默认访问权限。权限显示的含义在\u003ca class=\"xref\" href=\"/zh/docs/18/ddl-priv.html\" title=\"5.8. 权限\"\u003e第 5.8 节\u003c/a\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":"\\ddp"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\ddp"}],"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-DDP\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\ddp[x] [ \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\u003cp\u003e\n        Lists default access privilege settings.  An entry is shown for\n        each role (and schema, if applicable) for which the default\n        privilege settings have been changed from the built-in defaults.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only entries whose role name or schema name matches\n        the pattern are listed.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        \u003c/p\u003e\u003cp\u003e\n        The \u003ca class=\"link\" href=\"/docs/18/sql-alterdefaultprivileges.html\" title=\"ALTER DEFAULT PRIVILEGES\"\u003e\u003ccode class=\"command\"\u003eALTER DEFAULT\n        PRIVILEGES\u003c/code\u003e\u003c/a\u003e command is used to set default access\n        privileges.  The meaning of the privilege display is explained in\n        \u003ca class=\"xref\" href=\"/docs/18/ddl-priv.html\" title=\"5.8. Privileges\"\u003eSection 5.8\u003c/a\u003e.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DDP","modifiers":[{"command":"\\ddp","modifiers":"x"}],"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":"\\ddp[x] [ pattern ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DDP","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DDP"}],"spellings":["\\ddp"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\ddp","url":"/wiki/psql/cmd-64-64-70/?v=18"},"modifiers":"x"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\ddp","url":"/wiki/psql/cmd-64-64-70/?v=18"},"modifiers":"x"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DDP","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-DDP","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DDP"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64-64-70","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\ddp","Summary":"Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or schema name matches the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DDP\"\u003e\u003cspan\u003e\u003ccode\u003e\\ddp[x] [ \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\u003cp\u003e\n        Lists default access privilege settings.  An entry is shown for\n        each role (and schema, if applicable) for which the default\n        privilege settings have been changed from the built-in defaults.\n        If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only entries whose role name or schema name matches\n        the pattern are listed.\n        If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        \u003c/p\u003e\u003cp\u003e\n        The \u003ca href=\"/docs/18/sql-alterdefaultprivileges.html\" title=\"ALTER DEFAULT PRIVILEGES\" rel=\"nofollow\"\u003e\u003ccode\u003eALTER DEFAULT\n        PRIVILEGES\u003c/code\u003e\u003c/a\u003e command is used to set default access\n        privileges.  The meaning of the privilege display is explained in\n        \u003ca href=\"/docs/18/ddl-priv.html\" rel=\"nofollow\"\u003eSection 5.8\u003c/a\u003e.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"cac3004b02db319692410a790aa77f67921e73b89cca1d1588b1578cc32aa0f9","Payload":{"description":["Lists default access privilege settings. An entry is shown for each role (and schema, if applicable) for which the default privilege settings have been changed from the built-in defaults. If pattern is specified, only entries whose role name or schema name matches the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DDP\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\ddp[x] [ \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\u003cp\u003e\n        Lists default access privilege settings.  An entry is shown for\n        each role (and schema, if applicable) for which the default\n        privilege settings have been changed from the built-in defaults.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only entries whose role name or schema name matches\n        the pattern are listed.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        \u003c/p\u003e\u003cp\u003e\n        The \u003ca class=\"link\" href=\"/docs/18/sql-alterdefaultprivileges.html\" title=\"ALTER DEFAULT PRIVILEGES\"\u003e\u003ccode class=\"command\"\u003eALTER DEFAULT\n        PRIVILEGES\u003c/code\u003e\u003c/a\u003e command is used to set default access\n        privileges.  The meaning of the privilege display is explained in\n        \u003ca class=\"xref\" href=\"/docs/18/ddl-priv.html\" title=\"5.8. Privileges\"\u003eSection 5.8\u003c/a\u003e.\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":"\\ddp","url":"/wiki/psql/cmd-64-64-70/?v=18"},"modifiers":"x"}],"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":"\\ddp","Signature":"\\ddp[x] [ pattern ]","Modifiers":[{"command":"\\ddp","modifiers":"x"}]}],"SQLState":null,"Evidence":null}