{"Entry":{"collection":"psql","key":"cmd-64-76","name":"\\dv","aliases":["\\dv","\\dv+","\\dvS","\\dvS+","\\dvSx","\\dvSx+","\\dvx","\\dvx+"],"metadata":{"aliases":["\\dv","\\dv+","\\dvS","\\dvS+","\\dvSx","\\dvSx+","\\dvx","\\dvx+"],"category":"Describe database objects","content_hash":"f281085858e3434b03e5627f905e42601b7d93c64ec036049d05adbe322131f4","derived_content_hash":"ee3869c2c0b4e9ea8e8d40c309f2784325ef91213f0584933bbc9b76cd7307e0","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.950581+08:00","name":"\\dv","name_zh":"","slug":"cmd-64-76","summary":"In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}},"Definition":{"Collection":"psql","Key":"cmd-64-76","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64-76","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\dv","comparison_data":{"definition":"In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.","modifiers":[{"command":"\\dE","modifiers":"Sx+"},{"command":"\\di","modifiers":"Sx+"},{"command":"\\dm","modifiers":"Sx+"},{"command":"\\ds","modifiers":"Sx+"},{"command":"\\dt","modifiers":"Sx+"},{"command":"\\dv","modifiers":"Sx+"}],"signature":"\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]","spellings":["\\dE","\\di","\\dm","\\ds","\\dt","\\dv"]},"comparison_hash":"25d729c1c83f8c43a17e7dd60f0b8912d473db76af0afbc753d1071fe020c360","description":["In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."],"description_zh":"在这组命令中，字母 E 、 i 、 m 、 s 、 t 和 v 分别表示外部表、索引、物化视图、序列、表和视图。你可以按任意顺序指定其中任意一个或多个字母，以获取这些类型对象的列表。例如， \\dti 会列出表和索引。如果在命令名后追加 x ，结果会以扩展模式显示。如果在命令名后追加 + ，则每个对象都会连同其持久性状态（永久、临时或不记录 WAL）、磁盘上的物理大小以及相关描述（如果有）一起列出。如果指定了 pattern ，则只列出名称与模式匹配的对象。默认情况下，只显示用户创建的对象；提供模式或 S 修饰符可包括系统对象。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        在这组命令中，字母 \u003ccode class=\"literal\"\u003eE\u003c/code\u003e、\u003ccode class=\"literal\"\u003ei\u003c/code\u003e、\u003ccode class=\"literal\"\u003em\u003c/code\u003e、\u003ccode class=\"literal\"\u003es\u003c/code\u003e、\u003ccode class=\"literal\"\u003et\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003ev\u003c/code\u003e\n        分别表示外部表、索引、物化视图、序列、表和视图。你可以按任意顺序指定其中任意一个或多个字母，以获取这些类型对象的列表。例如，\u003ccode class=\"literal\"\u003e\\dti\u003c/code\u003e 会列出表和索引。如果在命令名后追加 \u003ccode class=\"literal\"\u003ex\u003c/code\u003e，结果会以扩展模式显示。如果在命令名后追加 \u003ccode class=\"literal\"\u003e+\u003c/code\u003e，则每个对象都会连同其持久性状态（永久、临时或不记录 WAL）、磁盘上的物理大小以及相关描述（如果有）一起列出。如果指定了 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e，则只列出名称与模式匹配的对象。默认情况下，只显示用户创建的对象；提供模式或 \u003ccode class=\"literal\"\u003eS\u003c/code\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":"\\dv"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\dv"}],"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-DE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dE[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\di[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dm[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\ds[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dt[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dv[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        In this group of commands, the letters \u003ccode class=\"literal\"\u003eE\u003c/code\u003e,\n        \u003ccode class=\"literal\"\u003ei\u003c/code\u003e, \u003ccode class=\"literal\"\u003em\u003c/code\u003e, \u003ccode class=\"literal\"\u003es\u003c/code\u003e,\n        \u003ccode class=\"literal\"\u003et\u003c/code\u003e, and \u003ccode class=\"literal\"\u003ev\u003c/code\u003e\n        stand for foreign table, index, materialized view,\n        sequence, table, and view,\n        respectively.\n        You can specify any or all of\n        these letters, in any order, to obtain a listing of objects\n        of these types.  For example, \u003ccode class=\"literal\"\u003e\\dti\u003c/code\u003e lists\n        tables and indexes.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is\n        appended to the command name, each object is listed with its\n        persistence status (permanent, temporary, or unlogged),\n        physical size on disk, and associated description if any.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only objects whose names match the pattern are listed.\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\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DE","modifiers":[{"command":"\\dE","modifiers":"Sx+"},{"command":"\\di","modifiers":"Sx+"},{"command":"\\dm","modifiers":"Sx+"},{"command":"\\ds","modifiers":"Sx+"},{"command":"\\dt","modifiers":"Sx+"},{"command":"\\dv","modifiers":"Sx+"}],"related":[{"label":"\\dE","url":"/wiki/psql/cmd-64-45/?v=18"},{"label":"\\di","url":"/wiki/psql/cmd-64-69/?v=18"},{"label":"\\dm","url":"/wiki/psql/cmd-64-6d/?v=18"},{"label":"\\ds","url":"/wiki/psql/cmd-64-73/?v=18"},{"label":"\\dt","url":"/wiki/psql/cmd-64-74/?v=18"},{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"\\dE","url":"/wiki/psql/cmd-64-45/?v=18"},{"label":"\\di","url":"/wiki/psql/cmd-64-69/?v=18"},{"label":"\\dm","url":"/wiki/psql/cmd-64-6d/?v=18"},{"label":"\\ds","url":"/wiki/psql/cmd-64-73/?v=18"},{"label":"\\dt","url":"/wiki/psql/cmd-64-74/?v=18"},{"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":"\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DE","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DE"}],"spellings":["\\dE","\\di","\\dm","\\ds","\\dt","\\dv"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\dE","url":"/wiki/psql/cmd-64-45/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\di","url":"/wiki/psql/cmd-64-69/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dm","url":"/wiki/psql/cmd-64-6d/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\ds","url":"/wiki/psql/cmd-64-73/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dt","url":"/wiki/psql/cmd-64-74/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dv","url":"/wiki/psql/cmd-64-76/?v=18"},"modifiers":"Sx+"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\dE","url":"/wiki/psql/cmd-64-45/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\di","url":"/wiki/psql/cmd-64-69/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dm","url":"/wiki/psql/cmd-64-6d/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\ds","url":"/wiki/psql/cmd-64-73/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dt","url":"/wiki/psql/cmd-64-74/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dv","url":"/wiki/psql/cmd-64-76/?v=18"},"modifiers":"Sx+"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DE","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-DE","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64-76","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\dv","Summary":"In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DE\"\u003e\u003cspan\u003e\u003ccode\u003e\\dE[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\u003cbr\u003e\u003c/span\u003e\u003cspan\u003e\u003ccode\u003e\\di[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\u003cbr\u003e\u003c/span\u003e\u003cspan\u003e\u003ccode\u003e\\dm[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\u003cbr\u003e\u003c/span\u003e\u003cspan\u003e\u003ccode\u003e\\ds[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\u003cbr\u003e\u003c/span\u003e\u003cspan\u003e\u003ccode\u003e\\dt[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\u003cbr\u003e\u003c/span\u003e\u003cspan\u003e\u003ccode\u003e\\dv[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        In this group of commands, the letters \u003ccode\u003eE\u003c/code\u003e,\n        \u003ccode\u003ei\u003c/code\u003e, \u003ccode\u003em\u003c/code\u003e, \u003ccode\u003es\u003c/code\u003e,\n        \u003ccode\u003et\u003c/code\u003e, and \u003ccode\u003ev\u003c/code\u003e\n        stand for foreign table, index, materialized view,\n        sequence, table, and view,\n        respectively.\n        You can specify any or all of\n        these letters, in any order, to obtain a listing of objects\n        of these types.  For example, \u003ccode\u003e\\dti\u003c/code\u003e lists\n        tables and indexes.\n        If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode\u003e+\u003c/code\u003e is\n        appended to the command name, each object is listed with its\n        persistence status (permanent, temporary, or unlogged),\n        physical size on disk, and associated description if any.\n        If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only objects whose names match the pattern are listed.\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\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"a4dc5e64f329bed38a3faa649064aa6fb13498e932dded5b99ea6df0ef936a90","Payload":{"description":["In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DE\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dE[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\di[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dm[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\ds[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dt[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\u003cbr\u003e\u003c/span\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dv[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        In this group of commands, the letters \u003ccode class=\"literal\"\u003eE\u003c/code\u003e,\n        \u003ccode class=\"literal\"\u003ei\u003c/code\u003e, \u003ccode class=\"literal\"\u003em\u003c/code\u003e, \u003ccode class=\"literal\"\u003es\u003c/code\u003e,\n        \u003ccode class=\"literal\"\u003et\u003c/code\u003e, and \u003ccode class=\"literal\"\u003ev\u003c/code\u003e\n        stand for foreign table, index, materialized view,\n        sequence, table, and view,\n        respectively.\n        You can specify any or all of\n        these letters, in any order, to obtain a listing of objects\n        of these types.  For example, \u003ccode class=\"literal\"\u003e\\dti\u003c/code\u003e lists\n        tables and indexes.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is\n        appended to the command name, each object is listed with its\n        persistence status (permanent, temporary, or unlogged),\n        physical size on disk, and associated description if any.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is\n        specified, only objects whose names match the pattern are listed.\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\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"\\dE","url":"/wiki/psql/cmd-64-45/?v=18"},{"label":"\\di","url":"/wiki/psql/cmd-64-69/?v=18"},{"label":"\\dm","url":"/wiki/psql/cmd-64-6d/?v=18"},{"label":"\\ds","url":"/wiki/psql/cmd-64-73/?v=18"},{"label":"\\dt","url":"/wiki/psql/cmd-64-74/?v=18"},{"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":"\\dE","url":"/wiki/psql/cmd-64-45/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\di","url":"/wiki/psql/cmd-64-69/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dm","url":"/wiki/psql/cmd-64-6d/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\ds","url":"/wiki/psql/cmd-64-73/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dt","url":"/wiki/psql/cmd-64-74/?v=18"},"modifiers":"Sx+"},{"command":{"text":"\\dv","url":"/wiki/psql/cmd-64-76/?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":"\\dE","Signature":"\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]","Modifiers":[{"command":"\\dE","modifiers":"Sx+"},{"command":"\\di","modifiers":"Sx+"},{"command":"\\dm","modifiers":"Sx+"},{"command":"\\ds","modifiers":"Sx+"},{"command":"\\dt","modifiers":"Sx+"},{"command":"\\dv","modifiers":"Sx+"}]},{"Version":"18","Ordinal":1,"Command":"\\di","Signature":"\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]","Modifiers":[{"command":"\\dE","modifiers":"Sx+"},{"command":"\\di","modifiers":"Sx+"},{"command":"\\dm","modifiers":"Sx+"},{"command":"\\ds","modifiers":"Sx+"},{"command":"\\dt","modifiers":"Sx+"},{"command":"\\dv","modifiers":"Sx+"}]},{"Version":"18","Ordinal":2,"Command":"\\dm","Signature":"\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]","Modifiers":[{"command":"\\dE","modifiers":"Sx+"},{"command":"\\di","modifiers":"Sx+"},{"command":"\\dm","modifiers":"Sx+"},{"command":"\\ds","modifiers":"Sx+"},{"command":"\\dt","modifiers":"Sx+"},{"command":"\\dv","modifiers":"Sx+"}]},{"Version":"18","Ordinal":3,"Command":"\\ds","Signature":"\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]","Modifiers":[{"command":"\\dE","modifiers":"Sx+"},{"command":"\\di","modifiers":"Sx+"},{"command":"\\dm","modifiers":"Sx+"},{"command":"\\ds","modifiers":"Sx+"},{"command":"\\dt","modifiers":"Sx+"},{"command":"\\dv","modifiers":"Sx+"}]},{"Version":"18","Ordinal":4,"Command":"\\dt","Signature":"\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]","Modifiers":[{"command":"\\dE","modifiers":"Sx+"},{"command":"\\di","modifiers":"Sx+"},{"command":"\\dm","modifiers":"Sx+"},{"command":"\\ds","modifiers":"Sx+"},{"command":"\\dt","modifiers":"Sx+"},{"command":"\\dv","modifiers":"Sx+"}]},{"Version":"18","Ordinal":5,"Command":"\\dv","Signature":"\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]","Modifiers":[{"command":"\\dE","modifiers":"Sx+"},{"command":"\\di","modifiers":"Sx+"},{"command":"\\dm","modifiers":"Sx+"},{"command":"\\ds","modifiers":"Sx+"},{"command":"\\dt","modifiers":"Sx+"},{"command":"\\dv","modifiers":"Sx+"}]}],"SQLState":null,"Evidence":null}