{"kind": "psql", "major": "18", "item": {"slug": "cmd-64-72-67", "name": "\\drg", "name_zh": "", "category": "\u63cf\u8ff0\u6570\u636e\u5e93\u5bf9\u8c61", "summary": "\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08 ADMIN \u3001 INHERIT \u548c/\u6216 SET \uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002", "aliases": ["\\drg", "\\drgS", "\\drgSx", "\\drgx"], "content_hash": "08745a64d59c5f19c6b44ac660b769682e125c98c83ee8e39983e9813029acbb", "versions": {"16": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.15"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\drg"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-72-67/?v=16", "text": "\\drg"}, "modifiers": "S"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\drg", "related": [{"url": "/wiki/tool/psql/?v=16", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/16/postgresql-16-A4.pdf", "bytes": 15282337, "pages": 3055, "sha256": "4bb6c1f63deedac98736d8c4c7bc0fad0ac24e85b07e21ee10411872f06afd06", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/16/postgresql-16-US.pdf", "bytes": 15164148, "pages": 3220, "sha256": "5b6b6166c89991199e144bb0ae34c17a5f29826251dbf19db1abc0df3a3e771b", "built_at": "2026-09-26"}}, "tree": "16", "index": "index.html", "major": "16", "pages": 1169, "release": "16.15", "source_url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "revision": "3c21e58b35318021716440e67bb8bafd392b6a2b965a244d90e9e33c99e0bdef", "evidence_kind": "English manual and source declarations", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "https://pg.center/docs/16/app-psql.html#APP-PSQL-META-COMMAND-DRG", "file": "app-psql.html", "label": "16.15 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DRG", "sha256": "add25957a1dfc97db721f2958782be186ab90dc0f0a47c4b720b2b6c26172493", "language": "en", "original_url": "/docs/16/app-psql.html#APP-PSQL-META-COMMAND-DRG"}], "sections": [], "modifiers": [{"command": "\\drg", "modifiers": "S"}], "signature": "\\drg[S] [ pattern ]", "spellings": ["\\drg"], "description": ["\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08 ADMIN \u3001 INHERIT \u548c/\u6216 SET \uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002"], "manual_html": "
\\drg[S] [ pattern ]
\n

\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08ADMIN\u3001INHERIT \u548c/\u6216 SET\uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002

\n

\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u6388\u4e88\u7528\u6237\u521b\u5efa\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\uff1b\u63d0\u4f9b S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u89d2\u8272\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u6388\u4e88\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DRG", "localization": {"status": "complete", "sources": [{"url": "/docs/16/app-psql.html", "method": "same-major semantic node", "sha256": "72833cd861534255277e73a650a16ab07f11c38db9df980213b8335751a3273d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[85]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[85]/p[1]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships.", "/versions/16/facts/0/label": "Client", "/versions/16/facts/1/label": "Case-sensitive spelling", "/versions/16/tables/0/title": "Spellings in this manual definition", "/versions/16/related/0/label": "psql command-line options and complete manual", "/versions/16/tables/0/columns/0/label": "Command", "/versions/16/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "64a6a34644256f824296595662c5f4c4e05fadb7146b0aa4fb8a467b40befdd9"}, "comparison_data": {"modifiers": [{"command": "\\drg", "modifiers": "S"}], "signature": "\\drg[S] [ pattern ]", "spellings": ["\\drg"], "definition": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships. By default, only grants to user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only grants to those roles whose names match the pattern are listed."}, "comparison_hash": "dfed828e5fb78b8e9cfcde8f3242d1a5cd0d8e08e364ac488702983f3b1c62f8", "manual_language": "zh"}, "17": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.11"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\drg"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-72-67/?v=17", "text": "\\drg"}, "modifiers": "S"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\drg", "related": [{"url": "/wiki/tool/psql/?v=17", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/17/postgresql-17-A4.pdf", "bytes": 15521293, "pages": 3099, "sha256": "1991354df0dc89e70ec39328c28988ef8b19c6a93671dab3893650b63e9f4e36", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/17/postgresql-17-US.pdf", "bytes": 15398150, "pages": 3270, "sha256": "07696c8f38abf31babf22d2db337093936e7c472d2af36d050b000c49bbcf52c", "built_at": "2026-09-26"}}, "tree": "17", "index": "index.html", "major": "17", "pages": 1143, "release": "17.11", "source_url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "revision": "58419c9b0dd42cb34c8d53695bb025a7e582edf55ccd4c5bcb1c2c7c71a37487", "evidence_kind": "English manual and source declarations", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "https://pg.center/docs/17/app-psql.html#APP-PSQL-META-COMMAND-DRG", "file": "app-psql.html", "label": "17.11 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DRG", "sha256": "04c77661f1c96a64e91a27313542c34aff0c7d2a94e350ed98c6f9f35700629b", "language": "en", "original_url": "/docs/17/app-psql.html#APP-PSQL-META-COMMAND-DRG"}], "sections": [], "modifiers": [{"command": "\\drg", "modifiers": "S"}], "signature": "\\drg[S] [ pattern ]", "spellings": ["\\drg"], "description": ["\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08 ADMIN \u3001 INHERIT \u548c/\u6216 SET \uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002"], "manual_html": "
\\drg[S] [ pattern ]
\n

\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08ADMIN\u3001INHERIT \u548c/\u6216 SET\uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002

\n

\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u6388\u4e88\u7528\u6237\u521b\u5efa\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\uff1b\u63d0\u4f9b S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u89d2\u8272\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u6388\u4e88\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DRG", "localization": {"status": "complete", "sources": [{"url": "/docs/17/app-psql.html", "method": "same-major semantic node", "sha256": "820a5ee48a79666cef06bfe375ea9337e7a347b6d32c921738edd824fe5aa9f8", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[85]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[85]/p[1]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships.", "/versions/17/facts/0/label": "Client", "/versions/17/facts/1/label": "Case-sensitive spelling", "/versions/17/tables/0/title": "Spellings in this manual definition", "/versions/17/related/0/label": "psql command-line options and complete manual", "/versions/17/tables/0/columns/0/label": "Command", "/versions/17/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "31e688be772b73d84b13112ef8c474940610b28a66a8d4e289dde3435486d4a5"}, "comparison_data": {"modifiers": [{"command": "\\drg", "modifiers": "S"}], "signature": "\\drg[S] [ pattern ]", "spellings": ["\\drg"], "definition": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships. By default, only grants to user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only grants to those roles whose names match the pattern are listed."}, "comparison_hash": "dfed828e5fb78b8e9cfcde8f3242d1a5cd0d8e08e364ac488702983f3b1c62f8", "manual_language": "zh"}, "18": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\drg"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-72-67/?v=18", "text": "\\drg"}, "modifiers": "Sx"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\drg", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DRG", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DRG", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DRG"}], "sections": [], "modifiers": [{"command": "\\drg", "modifiers": "Sx"}], "signature": "\\drg[Sx] [ pattern ]", "spellings": ["\\drg"], "description": ["\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08 ADMIN \u3001 INHERIT \u548c/\u6216 SET \uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002"], "manual_html": "
\\drg[Sx] [ pattern ]
\n

\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08ADMIN\u3001INHERIT \u548c/\u6216 SET\uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002

\n

\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u6388\u4e88\u7528\u6237\u521b\u5efa\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\uff1b\u63d0\u4f9b S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u89d2\u8272\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u6388\u4e88\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DRG", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[89]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[89]/p[1]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/0/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "eda88118010feb4eb63a76ff4b4251806926b2fe514fb9d08a3f59272bbcd1af"}, "comparison_data": {"modifiers": [{"command": "\\drg", "modifiers": "Sx"}], "signature": "\\drg[Sx] [ pattern ]", "spellings": ["\\drg"], "definition": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships. By default, only grants to user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only grants to those roles whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode."}, "comparison_hash": "178369c6b81e0d40db5cebb2c3c2f55a45c0d060c753521a8f44c71a8fa449ff", "manual_language": "zh"}, "19": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19beta4"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\drg"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-72-67/?v=19", "text": "\\drg"}, "modifiers": "Sx"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\drg", "related": [{"url": "/wiki/tool/psql/?v=19", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/19/postgresql-19-A4.pdf", "bytes": 16064841, "pages": 3052, "sha256": "4dd099e4125c591128fc5f3ebd02178dc24781f9e5ae629f96d67c4c8547427b", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/19/postgresql-19-US.pdf", "bytes": 15974616, "pages": 3225, "sha256": "61971fa857f0956d47341a0388fa6af9ae10acf691d4b2fc009007d384b0342b", "built_at": "2026-09-26"}}, "tree": "19", "index": "index.html", "major": "19", "pages": 1155, "release": "19beta4", "source_url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "svg_assets": 5, "source_mode": "en SGML built with pinned official archive", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833", "evidence_kind": "English manual and source declarations", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/app-psql.html#APP-PSQL-META-COMMAND-DRG", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DRG", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9", "language": "en", "original_url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-DRG"}], "sections": [], "modifiers": [{"command": "\\drg", "modifiers": "Sx"}], "signature": "\\drg[Sx] [ pattern ]", "spellings": ["\\drg"], "description": ["\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08 ADMIN \u3001 INHERIT \u548c/\u6216 SET \uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002"], "manual_html": "
\\drg[Sx] [ pattern ]
\n

\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08ADMIN\u3001INHERIT \u548c/\u6216 SET\uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002

\n

\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u6388\u4e88\u7528\u6237\u521b\u5efa\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\uff1b\u63d0\u4f9b S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u89d2\u8272\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u6388\u4e88\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DRG", "localization": {"status": "complete", "sources": [{"url": "/docs/19/app-psql.html", "method": "same-major semantic node", "sha256": "1351be06967585f99a84454a26dff346091ea378daf6c7ed9fa18edee9d1131c", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[89]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[89]/p[1]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships.", "/versions/19/facts/0/label": "Client", "/versions/19/facts/1/label": "Case-sensitive spelling", "/versions/19/tables/0/title": "Spellings in this manual definition", "/versions/19/related/0/label": "psql command-line options and complete manual", "/versions/19/tables/0/columns/0/label": "Command", "/versions/19/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "2a694460f6a960285c1afaadaa6bc64fd9ddd90a5c814d0d4254161f4d055b97"}, "comparison_data": {"modifiers": [{"command": "\\drg", "modifiers": "Sx"}], "signature": "\\drg[Sx] [ pattern ]", "spellings": ["\\drg"], "definition": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships. By default, only grants to user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only grants to those roles whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode."}, "comparison_hash": "178369c6b81e0d40db5cebb2c3c2f55a45c0d060c753521a8f44c71a8fa449ff", "manual_language": "zh"}, "20": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\drg"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-72-67/?v=20", "text": "\\drg"}, "modifiers": "Sx"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\drg", "related": [{"url": "/wiki/tool/psql/?v=20", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/20/postgresql-20-A4.pdf", "bytes": 16030631, "pages": 3052, "sha256": "bd5d82c0ce38fc18f92a0447818a91a193a261776bca1c37564bf9a683e177d0", "built_at": "2026-09-28"}, "US": {"url": "/files/documentation/pdf/20/postgresql-20-US.pdf", "bytes": 15936613, "pages": 3223, "sha256": "d97d9e0db479a02f4234b175f50fcad70c3661619afc8d6df9b9437882e3c299", "built_at": "2026-09-28"}}, "tree": "0", "index": "index.html", "major": "20", "pages": 1156, "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "svg_assets": 6, "source_mode": "en SGML built with pinned official archive", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_snapshot_utc": "26-Sep-2026 20:22"}, "revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918", "evidence_kind": "English manual and source declarations", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DRG", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DRG", "sha256": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87", "language": "en", "original_url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DRG"}], "sections": [], "modifiers": [{"command": "\\drg", "modifiers": "Sx"}], "signature": "\\drg[Sx] [ pattern ]", "spellings": ["\\drg"], "description": ["\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08 ADMIN \u3001 INHERIT \u548c/\u6216 SET \uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002"], "manual_html": "
\\drg[Sx] [ pattern ]
\n

\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08ADMIN\u3001INHERIT \u548c/\u6216 SET\uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002

\n

\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u6388\u4e88\u7528\u6237\u521b\u5efa\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\uff1b\u63d0\u4f9b S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u89d2\u8272\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u6388\u4e88\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DRG", "localization": {"status": "complete", "sources": [{"url": "/docs/devel/app-psql.html", "method": "same-major semantic node", "sha256": "1590b6e290ad21fe3ac1c1549628841ae426d1cd07a8f808789207878dbee5ab", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[89]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[89]/p[1]"]}], "language": "zh", "original_text": {"/summary": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships.", "/category": "Describe database objects", "/versions/20/description/0": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships.", "/versions/20/facts/0/label": "Client", "/versions/20/facts/1/label": "Case-sensitive spelling", "/versions/20/tables/0/title": "Spellings in this manual definition", "/versions/20/related/0/label": "psql command-line options and complete manual", "/versions/20/tables/0/columns/0/label": "Command", "/versions/20/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "73d33d7928855f5f40d67acf4e3d7d7db91caeff8d235075c5f3713b56a7922b"}, "comparison_data": {"modifiers": [{"command": "\\drg", "modifiers": "Sx"}], "signature": "\\drg[Sx] [ pattern ]", "spellings": ["\\drg"], "definition": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships. By default, only grants to user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only grants to those roles whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode."}, "comparison_hash": "178369c6b81e0d40db5cebb2c3c2f55a45c0d060c753521a8f44c71a8fa449ff", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\drg"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-72-67/?v=18", "text": "\\drg"}, "modifiers": "Sx"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\drg", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DRG", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DRG", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DRG"}], "sections": [], "modifiers": [{"command": "\\drg", "modifiers": "Sx"}], "signature": "\\drg[Sx] [ pattern ]", "spellings": ["\\drg"], "description": ["\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08 ADMIN \u3001 INHERIT \u548c/\u6216 SET \uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002"], "manual_html": "
\\drg[Sx] [ pattern ]
\n

\u5217\u51fa\u6bcf\u4e2a\u88ab\u6388\u4e88\u89d2\u8272\u6210\u5458\u8eab\u4efd\u7684\u4fe1\u606f\uff0c\u5305\u62ec\u88ab\u6388\u4e88\u7684\u9009\u9879\uff08ADMIN\u3001INHERIT \u548c/\u6216 SET\uff09\u4ee5\u53ca\u6388\u4e88\u8005\u3002\u5173\u4e8e\u89d2\u8272\u6210\u5458\u8eab\u4efd\uff0c\u53c2\u89c1 GRANT \u547d\u4ee4\u3002

\n

\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u6388\u4e88\u7528\u6237\u521b\u5efa\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\uff1b\u63d0\u4f9b S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u89d2\u8272\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u6388\u4e88\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u89d2\u8272\u7684\u6210\u5458\u8eab\u4efd\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DRG", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[89]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[89]/p[1]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/0/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "eda88118010feb4eb63a76ff4b4251806926b2fe514fb9d08a3f59272bbcd1af"}, "comparison_data": {"modifiers": [{"command": "\\drg", "modifiers": "Sx"}], "signature": "\\drg[Sx] [ pattern ]", "spellings": ["\\drg"], "definition": "Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships. By default, only grants to user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only grants to those roles whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode."}, "comparison_hash": "178369c6b81e0d40db5cebb2c3c2f55a45c0d060c753521a8f44c71a8fa449ff", "manual_language": "zh"}, "comparison": {"left": "15", "right": "16", "status": "added", "diff": "--- PostgreSQL 15\n+++ PostgreSQL 16\n@@ -1 +1,13 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+ \"definition\": \"Lists information about each granted role membership, including assigned options ( ADMIN , INHERIT and/or SET ) and grantor. See the GRANT command for information about role memberships. By default, only grants to user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only grants to those roles whose names match the pattern are listed.\",\n+ \"modifiers\": [\n+ {\n+ \"command\": \"\\\\drg\",\n+ \"modifiers\": \"S\"\n+ }\n+ ],\n+ \"signature\": \"\\\\drg[S] [ pattern ]\",\n+ \"spellings\": [\n+ \"\\\\drg\"\n+ ]\n+}"}}