{"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":"9f4276ace65467a21d928d8d94a299ca49f495d4e91fe0682339b239bd271a38","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":"english-manuals:111dc9ec381e33fc85e125a6f9bb3f4596a5112633302420840b2a2c671dc166","summary":"The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_shadow","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_shadow","SourceRevision":"english-manuals:111dc9ec381e33fc85e125a6f9bb3f4596a5112633302420840b2a2c671dc166","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},{"array_dimensions":0,"attnum":2,"description":"ID of this user","description_zh":"","documented":true,"documented_name":"usesysid","hidden":false,"name":"usesysid","not_null":false,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26},{"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},{"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},{"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},{"array_dimensions":0,"attnum":6,"description":"User bypasses every row-level security policy, see Section 5.9 for more information.","description_zh":"","documented":true,"documented_name":"usebypassrls","hidden":false,"name":"usebypassrls","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":7,"description":"Encrypted password; null if none. See pg_authid for details of how encrypted passwords are stored.","description_zh":"","documented":true,"documented_name":"passwd","hidden":false,"name":"passwd","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"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},{"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}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.30.5","file":"view-pg-shadow.html","lang":"en","sha256":"96e1041fa3d791d65dacbf06cce9e415f926717958c2b725550d11035afd1859","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_shadow","Summary":"视图pg_shadow存在是为了向后兼容性：它模拟了在PostgreSQL 8.1版本之前存在的目录。它显示了在pg_authid中rolcanlogin 为真的所有角色的属性。\n\n这个名称源于该表不应向公众开放读取，因为它包含密码。pg_user 是 pg_shadow 的公开可读视图，并隐藏密码字段。","BodyHTML":"\u003cp\u003e视图pg_shadow存在是为了向后兼容性：它模拟了在PostgreSQL 8.1版本之前存在的目录。它显示了在pg_authid中rolcanlogin 为真的所有角色的属性。\n\n这个名称源于该表不应向公众开放读取，因为它包含密码。pg_user 是 pg_shadow 的公开可读视图，并隐藏密码字段。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"773296e890a72ea50ba8e0128486291f96124f21b8dd81a2eef6ed33a681a835","Payload":{"columns":[{"description_zh":"用户名","name":"usename","type":"name","zh_from":"doc"},{"description_zh":"用户的ID","name":"usesysid","type":"oid","zh_from":"doc"},{"description_zh":"用户可创建数据库","name":"usecreatedb","type":"boolean","zh_from":"doc"},{"description_zh":"用户为一个超级用户","name":"usesuper","type":"boolean","zh_from":"doc"},{"description_zh":"用户可以发起流复制，并使系统进入或退出备份模式。","name":"userepl","type":"boolean","zh_from":"doc"},{"description_zh":"用户能否绕过所有的行级安全策略，详见第 5.9 节。","name":"usebypassrls","type":"boolean","zh_from":"doc"},{"description_zh":"加密后的密码；如果没有则为 NULL。关于加密密码的存储方式，见 pg_authid。","name":"passwd","type":"text","zh_from":"doc"},{"description_zh":"密码过期时间（仅用于密码认证）","name":"valuntil","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"运行时配置变量的会话默认值","name":"useconfig","type":"text[]","zh_from":"doc"}],"description_zh":"视图pg_shadow存在是为了向后兼容性：它模拟了在PostgreSQL 8.1版本之前存在的目录。它显示了在pg_authid中rolcanlogin 为真的所有角色的属性。\n\n这个名称源于该表不应向公众开放读取，因为它包含密码。pg_user 是 pg_shadow 的公开可读视图，并隐藏密码字段。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}