↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / psql 命令

\z

Lists tables, views and sequences with their associated access privileges. If a 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.

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义,以下显示原始英文内容。

Client
psql 18.6
Case-sensitive spelling
\z
command
\z
manual path
app-psql.html#APP-PSQL-META-COMMAND-Z
modifiers
map[command:\z modifiers:Sx]
signature
\z[Sx] [ pattern ]
spellings
\z

版本定义 PG 18

\z[Sx] [ pattern ]

Lists tables, views and sequences with their associated access privileges. If a 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.

This is an alias for \dp (“display privileges”).

精确保留大小写的命令写法

  • \z

Spellings in this manual definition

CommandDocumented suffix modifiers
\zSx

比较版本

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8

正文语言: en · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8