{"Entry":{"collection":"catalog","key":"pg_shadow","name":"pg_shadow","aliases":[],"metadata":{"changed_in":["8.1","9.1","9.5","12"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Password","name":"passwd","to":"Password (possibly encrypted)"},{"from":"User id (arbitrary number used to reference this user)","name":"usesysid","to":"User ID (arbitrary number used to reference this user)"},{"from":"Account expiry time (only used for password authentication)","name":"valuntil","to":"Password expiry time (only used for password authentication)"}],"from":"7.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"User ID (arbitrary number used to reference this user)","name":"usesysid","to":"ID of this user"}],"from":"8.0","listing":[],"order":false,"removed":[],"status":"changed","to":"8.1","types":[{"from":"int4","name":"usesysid","to":"oid"}],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"User may update system catalogs. (Even a superuser may not do this unless this column is true.)","name":"usecatupd","to":"User can update system catalogs. (Even a superuser cannot do this unless this column is true.)"},{"from":"User may create databases","name":"usecreatedb","to":"User can create databases"}],"from":"8.2","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.3","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Password (possibly encrypted)","name":"passwd","to":"Password (possibly encrypted); null if none. See pg_authid for details of how encrypted passwords are stored."}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":["userepl"],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","listing":[],"order":false,"removed":[],"status":"changed","to":"9.1","types":[],"unlisted":["userepl"]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.1","listing":["userepl"],"order":false,"removed":[],"status":"reworded","to":"9.2","types":[],"unlisted":[]},{"added":["usebypassrls"],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.4","listing":[],"order":false,"removed":["usecatupd"],"status":"changed","to":"9.5","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"User bypasses every row level security policy, see Section 5.7 for more information.","name":"usebypassrls","to":"User bypasses every row level security policy, see Section 5.8 for more information."}],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[{"from":"abstime","name":"valuntil","to":"timestamptz"}],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Password (possibly encrypted); null if none. See pg_authid for details of how encrypted passwords are stored.","name":"passwd","to":"Encrypted password; null if none. See pg_authid for details of how encrypted passwords are stored."}],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"User bypasses every row level security policy, see Section 5.8 for more information.","name":"usebypassrls","to":"User bypasses every row-level security policy, see Section 5.8 for more information."}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"User bypasses every row-level security policy, see Section 5.8 for more information.","name":"usebypassrls","to":"User bypasses every row-level security policy, see Section 5.9 for more information."}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"User bypasses every row-level security policy, see Section 5.9 for more information.","name":"usebypassrls","to":"User bypasses every row-level security policy, see Section 5.10 for more information."}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":9,"content_hash":"eef6e172f53d7db4b5848eb4afb67842817bbc1ea75e82ee4bf0d7f8aa12715b","derived_content_hash":"c8cad9729fd38df4b25623f518e6e1e5294a785af8110955d820671f8a7025b1","first_version":"7.4","imported_at":"2026-09-30T00:40:55.816149+08:00","kind":"view","last_version":"20","name":"pg_shadow","position":75,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:db876a96e9040881162b8be9463770d0935ff35daa674ddd50773f7647e87685","summary":"The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1.","summary_zh":"视图 pg_shadow 存在是为了向后兼容性：它模拟了在 PostgreSQL 8.1 版本之前存在的目录。它显示了在 pg_authid 中 rolcanlogin 为真的所有角色的属性。"}},"Definition":{"Collection":"catalog","Key":"pg_shadow","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_shadow","SourceRevision":"catalog-bilingual-repair:db876a96e9040881162b8be9463770d0935ff35daa674ddd50773f7647e87685","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"User name","description_zh":"用户名","documented":true,"documented_name":"usename","hidden":false,"name":"usename","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"ID of this user","description_zh":"用户的 ID","documented":true,"documented_name":"usesysid","hidden":false,"name":"usesysid","not_null":false,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"User can create databases","description_zh":"用户可创建数据库","documented":true,"documented_name":"usecreatedb","hidden":false,"name":"usecreatedb","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"User is a superuser","description_zh":"用户为一个超级用户","documented":true,"documented_name":"usesuper","hidden":false,"name":"usesuper","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"User can initiate streaming replication and put the system in and out of backup mode.","description_zh":"用户可以发起流复制，并使系统进入或退出备份模式。","documented":true,"documented_name":"userepl","hidden":false,"name":"userepl","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"User bypasses every row-level security policy, see Section 5.9 for more information.","description_zh":"用户能否绕过所有的行级安全策略，详见第 5.9 节。","documented":true,"documented_name":"usebypassrls","hidden":false,"name":"usebypassrls","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Encrypted password; null if none. See pg_authid for details of how encrypted passwords are stored.","description_zh":"加密后的密码；如果没有则为 NULL。关于加密密码的存储方式，见 pg_authid。","documented":true,"documented_name":"passwd","hidden":false,"name":"passwd","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Password expiry time (only used for password authentication)","description_zh":"密码过期时间（仅用于密码认证）","documented":true,"documented_name":"valuntil","hidden":false,"name":"valuntil","not_null":false,"references":"","type":"timestamptz","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Session defaults for run-time configuration variables","description_zh":"运行时配置变量的会话默认值","documented":true,"documented_name":"useconfig","hidden":false,"name":"useconfig","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"}],"description":"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.\n\nThe 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.","description_zh":"视图 pg_shadow 存在是为了向后兼容性：它模拟了在 PostgreSQL 8.1 版本之前存在的目录。它显示了在 pg_authid 中 rolcanlogin 为真的所有角色的属性。\n\n这个名称源于该表不应向公众开放读取，因为它包含密码。pg_user 是 pg_shadow 的公开可读视图，并隐藏密码字段。","description_zh_html":"\u003cp\u003e视图 pg_shadow 存在是为了向后兼容性：它模拟了在 PostgreSQL 8.1 版本之前存在的目录。它显示了在 pg_authid 中 rolcanlogin 为真的所有角色的属性。\u003c/p\u003e\n\u003cp\u003e这个名称源于该表不应向公众开放读取，因为它包含密码。pg_user 是 pg_shadow 的公开可读视图，并隐藏密码字段。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.30.5","file":"view-pg-shadow.html","lang":"en","sha256":"96e1041fa3d791d65dacbf06cce9e415f926717958c2b725550d11035afd1859","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["usename","usesysid","usecreatedb","usesuper","userepl","usebypassrls","passwd","valuntil","useconfig"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-shadow.html","sha256":"abbb90f538992df596b5c0e03b6b7ba37755057018cd7f8882bf4eba181e13d1","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:111dc9ec381e33fc85e125a6f9bb3f4596a5112633302420840b2a2c671dc166","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.30.5","file":"view-pg-shadow.html","lang":"en","sha256":"96e1041fa3d791d65dacbf06cce9e415f926717958c2b725550d11035afd1859","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-shadow.html","sha256":"abbb90f538992df596b5c0e03b6b7ba37755057018cd7f8882bf4eba181e13d1","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:111dc9ec381e33fc85e125a6f9bb3f4596a5112633302420840b2a2c671dc166","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["usename","usesysid","usecreatedb","usesuper","userepl","usebypassrls","passwd","valuntil","useconfig"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_shadow","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_shadow","Summary":"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.\n\nThe 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.","BodyHTML":"\u003cp\u003eThe 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.\n\nThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:db876a96e9040881162b8be9463770d0935ff35daa674ddd50773f7647e87685","ContentHash":"f022adac6f17ae50389182d4fa5a5af89feed5db607d6261b0712ae61f265c27","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"User name","description_zh":"用户名","documented":true,"documented_name":"usename","hidden":false,"name":"usename","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"ID of this user","description_zh":"用户的 ID","documented":true,"documented_name":"usesysid","hidden":false,"name":"usesysid","not_null":false,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"User can create databases","description_zh":"用户可创建数据库","documented":true,"documented_name":"usecreatedb","hidden":false,"name":"usecreatedb","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"User is a superuser","description_zh":"用户为一个超级用户","documented":true,"documented_name":"usesuper","hidden":false,"name":"usesuper","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"User can initiate streaming replication and put the system in and out of backup mode.","description_zh":"用户可以发起流复制，并使系统进入或退出备份模式。","documented":true,"documented_name":"userepl","hidden":false,"name":"userepl","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"User bypasses every row-level security policy, see Section 5.9 for more information.","description_zh":"用户能否绕过所有的行级安全策略，详见第 5.9 节。","documented":true,"documented_name":"usebypassrls","hidden":false,"name":"usebypassrls","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Encrypted password; null if none. See pg_authid for details of how encrypted passwords are stored.","description_zh":"加密后的密码；如果没有则为 NULL。关于加密密码的存储方式，见 pg_authid。","documented":true,"documented_name":"passwd","hidden":false,"name":"passwd","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Password expiry time (only used for password authentication)","description_zh":"密码过期时间（仅用于密码认证）","documented":true,"documented_name":"valuntil","hidden":false,"name":"valuntil","not_null":false,"references":"","type":"timestamptz","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Session defaults for run-time configuration variables","description_zh":"运行时配置变量的会话默认值","documented":true,"documented_name":"useconfig","hidden":false,"name":"useconfig","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"}],"description":"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.\n\nThe 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."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}