{"Entry":{"collection":"psql","key":"cmd-64","name":"\\d","aliases":["\\d","\\d+","\\dS","\\dS+","\\dSx","\\dSx+","\\dx","\\dx+"],"metadata":{"aliases":["\\d","\\d+","\\dS","\\dS+","\\dSx","\\dSx+","\\dx","\\dx+"],"category":"Describe database objects","content_hash":"502ff20bed90573970a48eb3afe41a56d83f75105bbf432e71a99b324a6807e4","derived_content_hash":"9d164215b82dd9c3abaf2f33bd497aab8e66879e501ccd195f5e239155faf1cb","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.75099+08:00","name":"\\d","name_zh":"","slug":"cmd-64","summary":"For each relation (table, view, materialized view, index, sequence, or foreign table) or composite type matching the pattern , show all columns, their types, the tablespace (if not the default) and any special attributes such as NOT NULL or defaults. Associated objects, such as indexes, constraints, rules, triggers, and publications, are also shown. For foreign tables, the associated foreign server is shown as well. ( “ Matching the pattern ” is defined in Patterns below.)"}},"Definition":{"Collection":"psql","Key":"cmd-64","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\d","comparison_data":{"definition":"For each relation (table, view, materialized view, index, sequence, or foreign table) or composite type matching the pattern , show all columns, their types, the tablespace (if not the default) and any special attributes such as NOT NULL or defaults. Associated indexes, constraints, rules, and triggers are also shown. For foreign tables, the associated foreign server is shown as well. ( “ Matching the pattern ” is defined in Patterns below.) For some types of relation, \\d shows additional information for each column: column values for sequences, indexed expressions for indexes, and foreign data wrapper options for foreign tables. The command form \\d+ is identical, except that more information is displayed: any comments associated with the columns of the table are shown, as is the presence of OIDs in the table, the view definition if the relation is a view, a non-default replica identity setting and the access method name if the relation has an access method. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. Note If \\d is used without a pattern argument, it is equivalent to \\dtvmsE which will show a list of all visible tables, views, materialized views, sequences and foreign tables. This is purely a convenience measure. As with many other commands, if x is appended to the command name, the results are displayed in expanded mode for this command only, but note that this only applies when \\d is used without a pattern argument or to describe a sequence. The same limitation on expanded output applies to \\x on and \\x auto . The x modifier cannot appear immediately after the \\d (because \\dx is a different command); the x modifier may only appear after an S or + modifier. For example, \\d+x is equivalent to \\dtvmsE+x and will show a list of all relations in expanded mode.","modifiers":[{"command":"\\d","modifiers":"Sx+"}],"signature":"\\d[Sx+] [ pattern ]","spellings":["\\d"]},"comparison_hash":"6ae2a701bc740560cd1479bd276f943a7351d1e16f9acba5592f15c17649c653","description":["For each relation (table, view, materialized view, index, sequence, or foreign table) or composite type matching the pattern , show all columns, their types, the tablespace (if not the default) and any special attributes such as NOT NULL or defaults. Associated indexes, constraints, rules, and triggers are also shown. For foreign tables, the associated foreign server is shown as well. ( “ Matching the pattern ” is defined in Patterns below.)"],"description_zh":"对于每个与 pattern 匹配的关系（表、视图、物化视图、索引、序列或外部表）或复合类型，显示所有列、它们的类型、表空间（如果不是默认的）以及任何特殊属性，如 NOT NULL 或默认值。还显示相关的索引、约束、规则和触发器。对于外部表，还显示关联的外部服务器。（ “ 匹配模式 ” 的定义在下面的 模式 中。）","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        对于每个与 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e 匹配的关系（表、视图、物化视图、索引、序列或外部表）或复合类型，显示所有列、它们的类型、表空间（如果不是默认的）以及任何特殊属性，如 \u003ccode class=\"literal\"\u003eNOT NULL\u003c/code\u003e 或默认值。还显示相关的索引、约束、规则和触发器。对于外部表，还显示关联的外部服务器。（\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e匹配模式\u003c/span\u003e”\u003c/span\u003e的定义在下面的\u003ca class=\"xref\" href=\"/zh/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"模式\"\u003e模式\u003c/a\u003e中。）\n        \u003c/p\u003e\u003cp\u003e\n        对于某些类型的关系，\u003ccode class=\"literal\"\u003e\\d\u003c/code\u003e 显示每列的附加信息：序列的列值，索引的索引表达式，外部表的外部数据包装器选项。\n        \u003c/p\u003e\u003cp\u003e\n        命令形式\u003ccode class=\"literal\"\u003e\\d+\u003c/code\u003e与前者相同，但会显示更多信息：表列关联的注释、表是否包含 OID、当关系为视图时的视图定义、非默认的\u003ca class=\"link\" href=\"/zh/docs/18/sql-altertable.html#SQL-ALTERTABLE-REPLICA-IDENTITY\"\u003e复制标识\u003c/a\u003e设置，以及当关系具有访问方法时的\u003ca class=\"link\" href=\"/zh/docs/18/sql-create-access-method.html\" title=\"CREATE ACCESS METHOD\"\u003e访问方法\u003c/a\u003e名称。\n        \u003c/p\u003e\u003cp\u003e\n        默认情况下，只显示用户创建的对象；提供一个模式或 \u003ccode class=\"literal\"\u003eS\u003c/code\u003e 修饰符以包括系统对象。\n        \u003c/p\u003e\u003cdiv class=\"note\"\u003e\u003ch3 class=\"title\"\u003e注意\u003c/h3\u003e\u003cp\u003e\n        如果使用\u003ccode class=\"command\"\u003e\\d\u003c/code\u003e 而没有 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e 参数，它等同于\u003ccode class=\"command\"\u003e\\dtvmsE\u003c/code\u003e，它将显示所有可见的表、视图、物化视图、序列和外部表的列表。这纯粹是一种便利措施。\n\u003c/p\u003e\u003cp\u003e\n        与许多其他命令一样，如果在命令名后追加 \u003ccode class=\"literal\"\u003ex\u003c/code\u003e，仅此命令的结果会以扩展模式显示。但请注意，这只适用于不带 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e 参数或用于描述序列的 \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e。同样的扩展输出限制也适用于 \u003ccode class=\"command\"\u003e\\x on\u003c/code\u003e 和 \u003ccode class=\"command\"\u003e\\x auto\u003c/code\u003e。\u003ccode class=\"literal\"\u003ex\u003c/code\u003e 修饰符不能直接紧跟在 \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e 后面（因为 \u003ccode class=\"command\"\u003e\\dx\u003c/code\u003e 是另一个命令）。\u003ccode class=\"literal\"\u003ex\u003c/code\u003e 只能出现在 \u003ccode class=\"literal\"\u003eS\u003c/code\u003e 或 \u003ccode class=\"literal\"\u003e+\u003c/code\u003e 修饰符之后。例如，\u003ccode class=\"command\"\u003e\\d+x\u003c/code\u003e 等同于 \u003ccode class=\"command\"\u003e\\dtvmsE+x\u003c/code\u003e，并以扩展模式显示所有关系的列表。\n        \u003c/p\u003e\u003c/div\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":"\\d"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\d"}],"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-D\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\d[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\u003cp\u003e\n        For each relation (table, view, materialized view, index, sequence,\n        or foreign table)\n        or composite type matching the\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e, show all\n        columns, their types, the tablespace (if not the default) and any\n        special attributes such as \u003ccode class=\"literal\"\u003eNOT NULL\u003c/code\u003e or defaults.\n        Associated indexes, constraints, rules, and triggers are\n        also shown.  For foreign tables, the associated foreign\n        server is shown as well.\n        (\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eMatching the pattern\u003c/span\u003e”\u003c/span\u003e is defined in\n        \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003ePatterns\u003c/a\u003e below.)\n        \u003c/p\u003e\u003cp\u003e\n        For some types of relation, \u003ccode class=\"literal\"\u003e\\d\u003c/code\u003e shows additional information\n        for each column: column values for sequences, indexed expressions for\n        indexes, and foreign data wrapper options for foreign tables.\n        \u003c/p\u003e\u003cp\u003e\n        The command form \u003ccode class=\"literal\"\u003e\\d+\u003c/code\u003e is identical, except that\n        more information is displayed: any comments associated with the\n        columns of the table are shown, as is the presence of OIDs in the\n        table, the view definition if the relation is a view, a non-default\n        \u003ca class=\"link\" href=\"/docs/18/sql-altertable.html#SQL-ALTERTABLE-REPLICA-IDENTITY\"\u003ereplica\n         identity\u003c/a\u003e setting and the\n        \u003ca class=\"link\" href=\"/docs/18/sql-create-access-method.html\" title=\"CREATE ACCESS METHOD\"\u003eaccess method\u003c/a\u003e name\n        if the relation has an access method.\n        \u003c/p\u003e\u003cp\u003e\n        By default, only user-created objects are shown;  supply a\n        pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e modifier to include system\n        objects.\n        \u003c/p\u003e\u003cdiv class=\"note\"\u003e\u003ch3 class=\"title\"\u003eNote\u003c/h3\u003e\u003cp\u003e\n        If \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e is used without a\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e argument, it is\n        equivalent to \u003ccode class=\"command\"\u003e\\dtvmsE\u003c/code\u003e which will show a list of\n        all visible tables, views, materialized views, sequences and\n        foreign tables.\n        This is purely a convenience measure.\n        \u003c/p\u003e\u003cp\u003e\n        As with many other commands, if \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to\n        the command name, the results are displayed in expanded mode for this\n        command only, but note that this only applies when \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e\n        is used without a \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\n        argument or to describe a sequence.\n        The same limitation on expanded output applies to\n        \u003ccode class=\"command\"\u003e\\x on\u003c/code\u003e and \u003ccode class=\"command\"\u003e\\x auto\u003c/code\u003e.\n        The \u003ccode class=\"literal\"\u003ex\u003c/code\u003e modifier cannot appear immediately after the\n        \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e (because \u003ccode class=\"command\"\u003e\\dx\u003c/code\u003e is a different\n        command); the \u003ccode class=\"literal\"\u003ex\u003c/code\u003e modifier may only appear after an\n        \u003ccode class=\"literal\"\u003eS\u003c/code\u003e or \u003ccode class=\"literal\"\u003e+\u003c/code\u003e modifier. For example,\n        \u003ccode class=\"command\"\u003e\\d+x\u003c/code\u003e is equivalent to \u003ccode class=\"command\"\u003e\\dtvmsE+x\u003c/code\u003e\n        and will show a list of all relations in expanded mode.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-D","modifiers":[{"command":"\\d","modifiers":"Sx+"}],"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":"\\d[Sx+] [ pattern ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-D","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-D"}],"spellings":["\\d"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\d","url":"/wiki/psql/cmd-64/?v=18"},"modifiers":"Sx+"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\d","url":"/wiki/psql/cmd-64/?v=18"},"modifiers":"Sx+"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-D","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-D","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-D"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\d","Summary":"For each relation (table, view, materialized view, index, sequence, or foreign table) or composite type matching the pattern , show all columns, their types, the tablespace (if not the default) and any special attributes such as NOT NULL or defaults. Associated indexes, constraints, rules, and triggers are also shown. For foreign tables, the associated foreign server is shown as well. ( “ Matching the pattern ” is defined in Patterns below.)","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-D\"\u003e\u003cspan\u003e\u003ccode\u003e\\d[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\u003cp\u003e\n        For each relation (table, view, materialized view, index, sequence,\n        or foreign table)\n        or composite type matching the\n        \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e, show all\n        columns, their types, the tablespace (if not the default) and any\n        special attributes such as \u003ccode\u003eNOT NULL\u003c/code\u003e or defaults.\n        Associated indexes, constraints, rules, and triggers are\n        also shown.  For foreign tables, the associated foreign\n        server is shown as well.\n        (\u003cspan\u003e“\u003cspan\u003eMatching the pattern\u003c/span\u003e”\u003c/span\u003e is defined in\n        \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\" rel=\"nofollow\"\u003ePatterns\u003c/a\u003e below.)\n        \u003c/p\u003e\u003cp\u003e\n        For some types of relation, \u003ccode\u003e\\d\u003c/code\u003e shows additional information\n        for each column: column values for sequences, indexed expressions for\n        indexes, and foreign data wrapper options for foreign tables.\n        \u003c/p\u003e\u003cp\u003e\n        The command form \u003ccode\u003e\\d+\u003c/code\u003e is identical, except that\n        more information is displayed: any comments associated with the\n        columns of the table are shown, as is the presence of OIDs in the\n        table, the view definition if the relation is a view, a non-default\n        \u003ca href=\"/docs/18/sql-altertable.html#SQL-ALTERTABLE-REPLICA-IDENTITY\" rel=\"nofollow\"\u003ereplica\n         identity\u003c/a\u003e setting and the\n        \u003ca href=\"/docs/18/sql-create-access-method.html\" title=\"CREATE ACCESS METHOD\" rel=\"nofollow\"\u003eaccess method\u003c/a\u003e name\n        if the relation has an access method.\n        \u003c/p\u003e\u003cp\u003e\n        By default, only user-created objects are shown;  supply a\n        pattern or the \u003ccode\u003eS\u003c/code\u003e modifier to include system\n        objects.\n        \u003c/p\u003e\u003cdiv\u003e\u003ch3\u003eNote\u003c/h3\u003e\u003cp\u003e\n        If \u003ccode\u003e\\d\u003c/code\u003e is used without a\n        \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e argument, it is\n        equivalent to \u003ccode\u003e\\dtvmsE\u003c/code\u003e which will show a list of\n        all visible tables, views, materialized views, sequences and\n        foreign tables.\n        This is purely a convenience measure.\n        \u003c/p\u003e\u003cp\u003e\n        As with many other commands, if \u003ccode\u003ex\u003c/code\u003e is appended to\n        the command name, the results are displayed in expanded mode for this\n        command only, but note that this only applies when \u003ccode\u003e\\d\u003c/code\u003e\n        is used without a \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\n        argument or to describe a sequence.\n        The same limitation on expanded output applies to\n        \u003ccode\u003e\\x on\u003c/code\u003e and \u003ccode\u003e\\x auto\u003c/code\u003e.\n        The \u003ccode\u003ex\u003c/code\u003e modifier cannot appear immediately after the\n        \u003ccode\u003e\\d\u003c/code\u003e (because \u003ccode\u003e\\dx\u003c/code\u003e is a different\n        command); the \u003ccode\u003ex\u003c/code\u003e modifier may only appear after an\n        \u003ccode\u003eS\u003c/code\u003e or \u003ccode\u003e+\u003c/code\u003e modifier. For example,\n        \u003ccode\u003e\\d+x\u003c/code\u003e is equivalent to \u003ccode\u003e\\dtvmsE+x\u003c/code\u003e\n        and will show a list of all relations in expanded mode.\n        \u003c/p\u003e\u003c/div\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"ed593840b8df083d51efd28dbdae4ac04d0c6ca121c381ba3ada6df0d40bf4a7","Payload":{"description":["For each relation (table, view, materialized view, index, sequence, or foreign table) or composite type matching the pattern , show all columns, their types, the tablespace (if not the default) and any special attributes such as NOT NULL or defaults. Associated indexes, constraints, rules, and triggers are also shown. For foreign tables, the associated foreign server is shown as well. ( “ Matching the pattern ” is defined in Patterns below.)"],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-D\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\d[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\u003cp\u003e\n        For each relation (table, view, materialized view, index, sequence,\n        or foreign table)\n        or composite type matching the\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e, show all\n        columns, their types, the tablespace (if not the default) and any\n        special attributes such as \u003ccode class=\"literal\"\u003eNOT NULL\u003c/code\u003e or defaults.\n        Associated indexes, constraints, rules, and triggers are\n        also shown.  For foreign tables, the associated foreign\n        server is shown as well.\n        (\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eMatching the pattern\u003c/span\u003e”\u003c/span\u003e is defined in\n        \u003ca class=\"xref\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003ePatterns\u003c/a\u003e below.)\n        \u003c/p\u003e\u003cp\u003e\n        For some types of relation, \u003ccode class=\"literal\"\u003e\\d\u003c/code\u003e shows additional information\n        for each column: column values for sequences, indexed expressions for\n        indexes, and foreign data wrapper options for foreign tables.\n        \u003c/p\u003e\u003cp\u003e\n        The command form \u003ccode class=\"literal\"\u003e\\d+\u003c/code\u003e is identical, except that\n        more information is displayed: any comments associated with the\n        columns of the table are shown, as is the presence of OIDs in the\n        table, the view definition if the relation is a view, a non-default\n        \u003ca class=\"link\" href=\"/docs/18/sql-altertable.html#SQL-ALTERTABLE-REPLICA-IDENTITY\"\u003ereplica\n         identity\u003c/a\u003e setting and the\n        \u003ca class=\"link\" href=\"/docs/18/sql-create-access-method.html\" title=\"CREATE ACCESS METHOD\"\u003eaccess method\u003c/a\u003e name\n        if the relation has an access method.\n        \u003c/p\u003e\u003cp\u003e\n        By default, only user-created objects are shown;  supply a\n        pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e modifier to include system\n        objects.\n        \u003c/p\u003e\u003cdiv class=\"note\"\u003e\u003ch3 class=\"title\"\u003eNote\u003c/h3\u003e\u003cp\u003e\n        If \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e is used without a\n        \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e argument, it is\n        equivalent to \u003ccode class=\"command\"\u003e\\dtvmsE\u003c/code\u003e which will show a list of\n        all visible tables, views, materialized views, sequences and\n        foreign tables.\n        This is purely a convenience measure.\n        \u003c/p\u003e\u003cp\u003e\n        As with many other commands, if \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to\n        the command name, the results are displayed in expanded mode for this\n        command only, but note that this only applies when \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e\n        is used without a \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\n        argument or to describe a sequence.\n        The same limitation on expanded output applies to\n        \u003ccode class=\"command\"\u003e\\x on\u003c/code\u003e and \u003ccode class=\"command\"\u003e\\x auto\u003c/code\u003e.\n        The \u003ccode class=\"literal\"\u003ex\u003c/code\u003e modifier cannot appear immediately after the\n        \u003ccode class=\"command\"\u003e\\d\u003c/code\u003e (because \u003ccode class=\"command\"\u003e\\dx\u003c/code\u003e is a different\n        command); the \u003ccode class=\"literal\"\u003ex\u003c/code\u003e modifier may only appear after an\n        \u003ccode class=\"literal\"\u003eS\u003c/code\u003e or \u003ccode class=\"literal\"\u003e+\u003c/code\u003e modifier. For example,\n        \u003ccode class=\"command\"\u003e\\d+x\u003c/code\u003e is equivalent to \u003ccode class=\"command\"\u003e\\dtvmsE+x\u003c/code\u003e\n        and will show a list of all relations in expanded mode.\n        \u003c/p\u003e\u003c/div\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":"\\d","url":"/wiki/psql/cmd-64/?v=18"},"modifiers":"Sx+"}],"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":"\\d","Signature":"\\d[Sx+] [ pattern ]","Modifiers":[{"command":"\\d","modifiers":"Sx+"}]}],"SQLState":null,"Evidence":null}