PostgreSQL 19 ← 18
← 目录图谱 / pg_shadow
SYSTEM VIEW · 系统视图
pg_shadow
The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. It shows properties of all roles that are marked as rolcanlogin in pg_authid. The name stems from the fact that this table should not be readable by the public since it contains passwords. pg_user is a publicly readable view on pg_shadow that blanks out the password field.
已与 PostgreSQL 18.6 实例逐字段核对 · 原始实测记录 ↗
字段结构 PostgreSQL 18
pg_shadowPostgreSQL 19 beta 3 是预发布快照，结构在正式发布前仍可能变化。
| 字段 / COLUMN | 类型 / TYPE | 说明 / DESCRIPTION |
|---|---|---|
usename |
name |
User name引用：pg_authid.rolname |
usesysid |
oid |
ID of this user引用：pg_authid.oid |
usecreatedb |
boolean文档原写法：bool |
User can create databases |
usesuper |
boolean文档原写法：bool |
User is a superuser |
userepl |
boolean文档原写法：bool |
User can initiate streaming replication and put the system in and out of backup mode. |
usebypassrls |
boolean文档原写法：bool |
User bypasses every row-level security policy, see Section 5.9 for more information. |
passwd |
text |
Encrypted password; null if none. See pg_authid for details of how encrypted passwords are stored. |
valuntil |
timestamp with time zone文档原写法：timestamptz |
Password expiry time (only used for password authentication) |
useconfig |
text[] |
Session defaults for run-time configuration variables |
标记“隐式列”的字段不包含在 SELECT * 中；部分早期统计视图由同版本源码补全，额外来源会显示在字段说明中。
通用系统列 0
PostgreSQL 提供的系统属性，通常不在 SELECT * 中展开。单独保留，不与普通字段混算。
| 字段 | 类型 | attnum |
|---|
字段演化矩阵
悬停查看字段类型存在新增 / 类型或属性变化移除
| 字段 / COLUMN | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
usename |
|||||||||||||||||
usesysid |
|||||||||||||||||
usecreatedb |
|||||||||||||||||
usesuper |
|||||||||||||||||
usecatupd |
− | – | – | – | – | – | – | – | – | – | – | – | |||||
passwd |
|||||||||||||||||
valuntil |
|||||||||||||||||
useconfig |
|||||||||||||||||
userepl |
– | ||||||||||||||||
usebypassrls |
– | – | – | – | – |
9.0 是收录基线；基线中已存在的字段不标记为新增。矩阵按字段名称对齐，重命名显示为旧字段移除与新字段新增。
演化时间线
相邻大版本的变化PostgreSQL 17 ← 16
PostgreSQL 14 ← 13
PostgreSQL 13 ← 12
PostgreSQL 12 ← 11
PostgreSQL 9.5 ← 9.4
PostgreSQL 9.1 ← 9.0
比较任意两个版本
选择两个版本，查看字段的新增、移除与类型变化。交互比较需要 JavaScript；演化时间线可直接阅读。