pg_authid

字段

PostgreSQL 18 的 12 个字段，按定义顺序排列。说明默认用本站手册的译文，没有译文的按英文原文显示。

演化历史

相邻两个大版本之间的差异，新的在前。版本号链到该版的字段表。

1. PostgreSQL 19 ← 18 仅描述更新

   1 处描述更新

   • rolbypassrls Role bypasses every row-level security policy, see Section 5.9 for more information. Role bypasses every row-level security policy, see Section 5.10 for more information.

2. PostgreSQL 17 ← 16 仅描述更新

   关系说明更新

   1 处描述更新

   • rolbypassrls Role bypasses every row-level security policy, see Section 5.8 for more information. Role bypasses every row-level security policy, see Section 5.9 for more information.

3. PostgreSQL 14 ← 13 仅描述更新

   关系说明更新

   1 处描述更新

   • rolbypassrls Role bypasses every row level security policy, see Section 5.8 for more information. Role bypasses every row-level security policy, see Section 5.8 for more information.

4. PostgreSQL 13 ← 12 仅描述更新

   1 处描述更新

   • rolpassword Password (possibly encrypted); null if none. The format depends on the form of encryption used. Encrypted password; null if none. The format depends on the form of encryption used.

5. PostgreSQL 12 ← 11 结构变更

   oid：隐式列 → 常规列

   2 处描述更新

   • oid Row identifier (hidden attribute; must be explicitly selected) Row identifier
   • rolbypassrls Role bypasses every row level security policy, see Section 5.7 for more information. Role bypasses every row level security policy, see Section 5.8 for more information.

6. PostgreSQL 10 ← 9.6 仅描述更新

   关系说明更新

   1 处描述更新

   • rolpassword Password (possibly encrypted); null if none. If the password is encrypted, this column will begin with the string md5 followed by a 32-character hexadecimal MD5 hash. The MD5 hash will be of the user's password concatenated to their user name. For example, if user joe has password xyzzy, PostgreSQL will store the md5 hash of xyzzyjoe. A password that does not follow that format is assumed to be unencrypted. Password (possibly encrypted); null if none. The format depends on the form of encryption used.

7. PostgreSQL 9.6 ← 9.5 仅描述更新

   关系说明更新

   1 处描述更新

   • rolreplication Role is a replication role. That is, this role can initiate streaming replication (see Section 25.2.5) and set/unset the system backup mode using pg_start_backup and pg_stop_backup Role is a replication role. A replication role can initiate replication connections and create and drop replication slots.

8. PostgreSQL 9.5 ← 9.4 结构变更

   +rolbypassrls −rolcatupdate

   1 处描述更新

   • rolcanlogin Role can log in. That is, this role can be given as the initial session authorization identifier Role can log in. That is, this role can be given as the initial session authorization identifier.

9. PostgreSQL 9.3 ← 9.2 仅描述更新

   1 处描述更新

   • oid Row identifier (hidden system attribute; explicitly select oid). Row identifier (hidden attribute; must be explicitly selected)

10. PostgreSQL 9.1 ← 9.0 结构变更

    +rolreplication

    1 处描述更新

    • rolpassword Password (possibly encrypted); null if none. If the password is encrypted, this column will contain the string md5 followed by a 32-character hexadecimal MD5 hash. The MD5 hash will be of the user's password concatenated to their username (for example, if user joe has password xyzzy, PostgreSQL will store the md5 hash of xyzzyjoe). Password (possibly encrypted); null if none. If the password is encrypted, this column will begin with the string md5 followed by a 32-character hexadecimal MD5 hash. The MD5 hash will be of the user's password concatenated to their user name. For example, if user joe has password xyzzy, PostgreSQL will store the md5 hash of xyzzyjoe. A password that does not follow that format is assumed to be unencrypted.

字段矩阵

每个字段在 18 个收录版本里的存在情况；方格指向该版的字段表。「有变」指类型、可空、隐式或数组维数与上一版不同。

存在 有变 已移除 不存在

系统列

同类关系