{"Entry":{"collection":"catalog","key":"pg_user","name":"pg_user","aliases":[],"metadata":{"changed_in":["9.1","9.5","12"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"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":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":["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":"User ID (arbitrary number used to reference this user)","name":"usesysid","to":"ID of this user"}],"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":"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":"0b2884962ae7deca019f5e6fe50704e76c570fd73f57c46a5cc0733e8e8f13cb","derived_content_hash":"225e6e60e1032ed72fba0311253ec2c37cae6edd5aa672d9cafe4803ad6d9a32","first_version":"7.4","imported_at":"2026-09-30T00:40:56.416456+08:00","kind":"view","last_version":"20","name":"pg_user","position":150,"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:16ad3eabe766db69c65a8e0703e2f2fd2478c23104574833a712eb021ae9e21b","summary":"The view pg_user provides access to information about database users.","summary_zh":"视图 pg_user 提供数据库用户的信息。它本质上是 pg_shadow 的公开可读视图，并隐藏密码字段的内容。"}},"Definition":{"Collection":"catalog","Key":"pg_user","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_user","SourceRevision":"catalog-bilingual-repair:16ad3eabe766db69c65a8e0703e2f2fd2478c23104574833a712eb021ae9e21b","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":"","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":"","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":"Not the password (always reads as ********)","description_zh":"不是密码（始终显示为 ********）","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_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the password field.","description_zh":"视图 pg_user 提供数据库用户的信息。它本质上是 pg_shadow 的公开可读视图，并隐藏密码字段。","description_zh_html":"\u003cp\u003e视图 pg_user 提供数据库用户的信息。它本质上是 pg_shadow 的公开可读视图，并隐藏密码字段。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.39.4","file":"view-pg-user.html","lang":"en","sha256":"a5321565e01a5c4835ab459bac74c5931c0183b51fb9fc21d45cfd0ae5dba553","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-user.html","sha256":"5d8128db21a106ff07e8b2598b8a31cfea0be1b336afdf90859f1bae19ea481d","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:36ccf64f06ffdbea8f15724542ece11aab521a83aa00df12ed8a6d427ff7f043","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.39.4","file":"view-pg-user.html","lang":"en","sha256":"a5321565e01a5c4835ab459bac74c5931c0183b51fb9fc21d45cfd0ae5dba553","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-user.html","sha256":"5d8128db21a106ff07e8b2598b8a31cfea0be1b336afdf90859f1bae19ea481d","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:36ccf64f06ffdbea8f15724542ece11aab521a83aa00df12ed8a6d427ff7f043","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_user","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_user","Summary":"The view pg_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the password field.","BodyHTML":"\u003cp\u003eThe view pg_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the password field.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:16ad3eabe766db69c65a8e0703e2f2fd2478c23104574833a712eb021ae9e21b","ContentHash":"78b691b0ea44ebb579de6a98898ff3021c6186aeda5053308b7d2a6cbb8f9171","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":"","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":"","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":"Not the password (always reads as ********)","description_zh":"不是密码（始终显示为 ********）","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_user provides access to information about database users. This is simply a publicly readable view of 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}