百科 / psql 命令 / 描述数据库对象

\dp

列出表、视图和序列及其相关访问权限。如果指定了 pattern ，则只列出名称与模式匹配的表、视图和序列。默认情况下，只显示用户创建的对象；提供模式或 S 修饰符可包括系统对象。如果在命令名后追加 x ，结果会以扩展模式显示。

当前查看 PostgreSQL 18.6。

说明

客户端: psql 18.6
区分大小写的写法: \dp

用法

\dp[Sx] [ pattern ]

本版手册中的写法

命令	手册中的后缀修饰符
\dp	Sx

手册定义

\dp[Sx] [ pattern ]

列出表、视图和序列及其相关访问权限。如果指定了 pattern，则只列出名称与模式匹配的表、视图和序列。默认情况下，只显示用户创建的对象；提供模式或 S 修饰符可包括系统对象。如果在命令名后追加 x，结果会以扩展模式显示。

GRANT和 REVOKE 命令用于设置访问权限。权限显示的含义在第 5.8 节中有解释。

文档与源码

18.6 English manual · app-psql.html

来源构建

版本: 18.6
构建: https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
来源指纹: ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8

版本比较

PostgreSQL 18 → 19: 属性变化。

以下差异保留原始字段名与英文源描述。

--- PostgreSQL 18
+++ PostgreSQL 19
@@ -1,5 +1,5 @@
 {
-  "definition": "Lists tables, views and sequences with their associated access privileges. If pattern is specified, only tables, views and sequences 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. If x is appended to the command name, the results are displayed in expanded mode. The GRANT and REVOKE commands are used to set access privileges. The meaning of the privilege display is explained in Section 5.8 .",
+  "definition": "Lists tables, views and sequences with their associated access privileges. If pattern is specified, only tables, views and sequences 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. If x is appended to the command name, the results are displayed in expanded mode. The GRANT and REVOKE commands are used to set access privileges. The meaning of the privilege display is explained in Section 5.9 .",
   "modifiers": [
     {
       "command": "\\dp",

比较已记录的接口与属性，排除来源指纹和构建元数据。某个样本中没有记录，不能据此判断实际引入或移除的版本。

快速链接

\dp

说明