{"Entry":{"collection":"psql","key":"cmd-64-72-64-73","name":"\\drds","aliases":["\\drds","\\drdsx"],"metadata":{"aliases":["\\drds","\\drdsx"],"category":"Describe database objects","content_hash":"77a36d97db7eb4414119b1b0789f24ceb58df0b733bc4bf3680ef5cb99399fc3","derived_content_hash":"95f6de17d742e0b55d8f7c4abafb747a9aa129b59ab82fe422edbcd251169a2c","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.927878+08:00","name":"\\drds","name_zh":"","slug":"cmd-64-72-64-73","summary":"Lists defined configuration settings. These settings can be role-specific, database-specific, or both. role-pattern and database-pattern are used to select specific roles and databases to list, respectively. If omitted, or if * is specified, all settings are listed, including those not role-specific or database-specific, respectively. If x is appended to the command name, the results are displayed in expanded mode."}},"Definition":{"Collection":"psql","Key":"cmd-64-72-64-73","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64-72-64-73","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\drds","comparison_data":{"definition":"Lists defined configuration settings. These settings can be role-specific, database-specific, or both. role-pattern and database-pattern are used to select specific roles and databases to list, respectively. If omitted, or if * is specified, all settings are listed, including those not role-specific or database-specific, respectively. If x is appended to the command name, the results are displayed in expanded mode. The ALTER ROLE and ALTER DATABASE commands are used to define per-role and per-database configuration settings.","modifiers":[{"command":"\\drds","modifiers":"x"}],"signature":"\\drds[x] [ role-pattern [ database-pattern ] ]","spellings":["\\drds"]},"comparison_hash":"3601709addc39c06d71ee6614b7e0a8ab858107a5fee56b5539139a555cf0195","description":["Lists defined configuration settings. These settings can be role-specific, database-specific, or both. role-pattern and database-pattern are used to select specific roles and databases to list, respectively. If omitted, or if * is specified, all settings are listed, including those not role-specific or database-specific, respectively. If x is appended to the command name, the results are displayed in expanded mode."],"description_zh":"列出已定义的配置设置。这些设置可以特定于角色、特定于数据库，或同时特定于两者。 role-pattern 和 database-pattern 分别用于选择要列出的角色和数据库。省略某个模式参数或将其指定为 * 时，不会按该参数筛选，还会分别包含不特定于角色或不特定于数据库的设置。如果在命令名后追加 x ，结果会以扩展模式显示。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        列出已定义的配置设置。这些设置可以特定于角色、特定于数据库，或同时特定于两者。\u003cem class=\"replaceable\"\u003e\u003ccode\u003erole-pattern\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"replaceable\"\u003e\u003ccode\u003edatabase-pattern\u003c/code\u003e\u003c/em\u003e 分别用于选择要列出的角色和数据库。省略某个模式参数或将其指定为\u003ccode class=\"literal\"\u003e*\u003c/code\u003e 时，不会按该参数筛选，还会分别包含不特定于角色或不特定于数据库的设置。如果在命令名后追加 \u003ccode class=\"literal\"\u003ex\u003c/code\u003e，结果会以扩展模式显示。\n        \u003c/p\u003e\u003cp\u003e\n\u003ca class=\"link\" href=\"/zh/docs/18/sql-alterrole.html\" title=\"ALTER ROLE\"\u003e\u003ccode class=\"command\"\u003eALTER ROLE\u003c/code\u003e\u003c/a\u003e 和\n        \u003ca class=\"link\" href=\"/zh/docs/18/sql-alterdatabase.html\" title=\"ALTER DATABASE\"\u003e\u003ccode class=\"command\"\u003eALTER DATABASE\u003c/code\u003e\u003c/a\u003e\n        命令用于定义每个角色和每个数据库的配置设置。\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":"\\drds"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\drds"}],"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-DRDS\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\drds[x] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003erole-pattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003edatabase-pattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists defined configuration settings.  These settings can be\n        role-specific, database-specific, or both.\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003erole-pattern\u003c/code\u003e\u003c/em\u003e and\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003edatabase-pattern\u003c/code\u003e\u003c/em\u003e are used to select\n        specific roles and databases to list, respectively.  If omitted, or if\n        \u003ccode class=\"literal\"\u003e*\u003c/code\u003e is specified, all settings are listed, including those\n        not role-specific or database-specific, respectively.\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-alterrole.html\" title=\"ALTER ROLE\"\u003e\u003ccode class=\"command\"\u003eALTER ROLE\u003c/code\u003e\u003c/a\u003e and\n        \u003ca class=\"link\" href=\"/docs/18/sql-alterdatabase.html\" title=\"ALTER DATABASE\"\u003e\u003ccode class=\"command\"\u003eALTER DATABASE\u003c/code\u003e\u003c/a\u003e\n        commands are used to define per-role and per-database configuration\n        settings.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DRDS","modifiers":[{"command":"\\drds","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":"\\drds[x] [ role-pattern [ database-pattern ] ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DRDS","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DRDS"}],"spellings":["\\drds"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\drds","url":"/wiki/psql/cmd-64-72-64-73/?v=18"},"modifiers":"x"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\drds","url":"/wiki/psql/cmd-64-72-64-73/?v=18"},"modifiers":"x"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DRDS","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-DRDS","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DRDS"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64-72-64-73","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\drds","Summary":"Lists defined configuration settings. These settings can be role-specific, database-specific, or both. role-pattern and database-pattern are used to select specific roles and databases to list, respectively. If omitted, or if * is specified, all settings are listed, including those not role-specific or database-specific, respectively. 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-DRDS\"\u003e\u003cspan\u003e\u003ccode\u003e\\drds[x] [ \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\" rel=\"nofollow\"\u003e\u003cem\u003e\u003ccode\u003erole-pattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\" rel=\"nofollow\"\u003e\u003cem\u003e\u003ccode\u003edatabase-pattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists defined configuration settings.  These settings can be\n        role-specific, database-specific, or both.\n        \u003cem\u003e\u003ccode\u003erole-pattern\u003c/code\u003e\u003c/em\u003e and\n        \u003cem\u003e\u003ccode\u003edatabase-pattern\u003c/code\u003e\u003c/em\u003e are used to select\n        specific roles and databases to list, respectively.  If omitted, or if\n        \u003ccode\u003e*\u003c/code\u003e is specified, all settings are listed, including those\n        not role-specific or database-specific, respectively.\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-alterrole.html\" title=\"ALTER ROLE\" rel=\"nofollow\"\u003e\u003ccode\u003eALTER ROLE\u003c/code\u003e\u003c/a\u003e and\n        \u003ca href=\"/docs/18/sql-alterdatabase.html\" title=\"ALTER DATABASE\" rel=\"nofollow\"\u003e\u003ccode\u003eALTER DATABASE\u003c/code\u003e\u003c/a\u003e\n        commands are used to define per-role and per-database configuration\n        settings.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"4ecb087af371ab3ce5a458ee3b50fda783695cc5865bc343ed0437c6a1a98df1","Payload":{"description":["Lists defined configuration settings. These settings can be role-specific, database-specific, or both. role-pattern and database-pattern are used to select specific roles and databases to list, respectively. If omitted, or if * is specified, all settings are listed, including those not role-specific or database-specific, respectively. 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-DRDS\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\drds[x] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003erole-pattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003edatabase-pattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists defined configuration settings.  These settings can be\n        role-specific, database-specific, or both.\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003erole-pattern\u003c/code\u003e\u003c/em\u003e and\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003edatabase-pattern\u003c/code\u003e\u003c/em\u003e are used to select\n        specific roles and databases to list, respectively.  If omitted, or if\n        \u003ccode class=\"literal\"\u003e*\u003c/code\u003e is specified, all settings are listed, including those\n        not role-specific or database-specific, respectively.\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-alterrole.html\" title=\"ALTER ROLE\"\u003e\u003ccode class=\"command\"\u003eALTER ROLE\u003c/code\u003e\u003c/a\u003e and\n        \u003ca class=\"link\" href=\"/docs/18/sql-alterdatabase.html\" title=\"ALTER DATABASE\"\u003e\u003ccode class=\"command\"\u003eALTER DATABASE\u003c/code\u003e\u003c/a\u003e\n        commands are used to define per-role and per-database configuration\n        settings.\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":"\\drds","url":"/wiki/psql/cmd-64-72-64-73/?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":"\\drds","Signature":"\\drds[x] [ role-pattern [ database-pattern ] ]","Modifiers":[{"command":"\\drds","modifiers":"x"}]}],"SQLState":null,"Evidence":null}