{"Entry":{"collection":"catalog","key":"pg_init_privs","name":"pg_init_privs","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.5","order":false,"removed":[],"status":"added","to":"9.6","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The initial access privileges; see GRANT and REVOKE for details","name":"initprivs","to":"The initial access privileges; see Section 5.7 for details"}],"from":"11","listing":[],"order":false,"removed":[],"status":"reworded","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The initial access privileges; see Section 5.7 for details","name":"initprivs","to":"The initial access privileges; see Section 5.8 for details"}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The initial access privileges; see Section 5.8 for details","name":"initprivs","to":"The initial access privileges; see Section 5.9 for details"}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":5,"content_hash":"40ff9bc1ee59c5f4fb0a4c8ad937de7d274589d4139a4496eb440c04b6536b3a","derived_content_hash":"a320c405871e2bc606de9a0301819f3f9325f6d030a01633fcceed2131418463","first_version":"9.6","imported_at":"2026-09-30T00:40:55.587175+08:00","kind":"catalog","last_version":"20","name":"pg_init_privs","position":39,"present_in":["9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:329a318f31f2ac09f9fd593a7d3c5cc9b9f5238eb23cfddb8eec3a8aead3ebe2","summary":"The catalog pg_init_privs records information about the initial privileges of objects in the system.","summary_zh":"目录 pg_init_privs 记录系统中对象的初始权限。数据库中每个具有非默认（非 NULL）初始权限集合的对象都在其中有一个条目。"}},"Definition":{"Collection":"catalog","Key":"pg_init_privs","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_init_privs","SourceRevision":"catalog-bilingual-repair:329a318f31f2ac09f9fd593a7d3c5cc9b9f5238eb23cfddb8eec3a8aead3ebe2","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the specific object","description_zh":"指定对象的 OID","documented":true,"documented_name":"objoid","hidden":false,"name":"objoid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the system catalog the object is in","description_zh":"对象所在的系统目录的 OID","documented":true,"documented_name":"classoid","hidden":false,"name":"classoid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"For a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero.","description_zh":"对于一个表列，这里是列编号（objoid 和 classoid 指向表本身）。对于所有其他对象类型，这列为零。","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"A code defining the type of initial privilege of this object; see text","description_zh":"定义此对象初始权限类型的代码，见文字说明","documented":true,"documented_name":"privtype","hidden":false,"name":"privtype","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":5,"description":"The initial access privileges; see Section 5.8 for details","description_zh":"初始的访问权限，详见第 5.8 节","documented":true,"documented_name":"initprivs","hidden":false,"name":"initprivs","not_null":true,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034,"zh_from":"same-version-manual"}],"description":"The catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the database which has a non-default (non-NULL) initial set of privileges.\n\nObjects can have initial privileges either by having those privileges set when the system is initialized (by initdb) or when the object is created during a CREATE EXTENSION and the extension script sets initial privileges using the GRANT system. Note that the system will automatically handle recording of the privileges during the extension script and that extension authors need only use the GRANT and REVOKE statements in their script to have the privileges recorded. The privtype column indicates if the initial privilege was set by initdb or during a CREATE EXTENSION command.\n\nObjects which have initial privileges set by initdb will have entries where privtype is 'i', while objects which have initial privileges set by CREATE EXTENSION will have entries where privtype is 'e'.","description_zh":"目录 pg_init_privs 记录系统中对象的初始权限。数据库中每个具有非默认（非 NULL）初始权限集合的对象都在其中有一个条目。\n\n对象可以在系统初始化（initdb）时获得其初始权限，也可以在 CREATE EXTENSION 期间创建该对象，并在扩展脚本中用 GRANT 设置对象的初始权限。注意，系统会自动处理扩展脚本执行期间对权限的记录；扩展作者只需要在脚本中使用 GRANT 和 REVOKE 语句，权限就会被记录下来。privtype 列表示初始权限是由 initdb 设置，还是在某次 CREATE EXTENSION 命令期间设置。\n\n对于初始权限由 initdb 设置的对象，其条目中的 privtype 是'i'；对于初始权限由 CREATE EXTENSION 设置的对象，其条目中的 privtype 为'e'。","description_zh_html":"\u003cp\u003e目录 pg_init_privs 记录系统中对象的初始权限。数据库中每个具有非默认（非 NULL）初始权限集合的对象都在其中有一个条目。\u003c/p\u003e\n\u003cp\u003e对象可以在系统初始化（initdb）时获得其初始权限，也可以在 CREATE EXTENSION 期间创建该对象，并在扩展脚本中用 GRANT 设置对象的初始权限。注意，系统会自动处理扩展脚本执行期间对权限的记录；扩展作者只需要在脚本中使用 GRANT 和 REVOKE 语句，权限就会被记录下来。privtype 列表示初始权限是由 initdb 设置，还是在某次 CREATE EXTENSION 命令期间设置。\u003c/p\u003e\n\u003cp\u003e对于初始权限由 initdb 设置的对象，其条目中的 privtype 是\u0026#x27;i\u0026#x27;；对于初始权限由 CREATE EXTENSION 设置的对象，其条目中的 privtype 为\u0026#x27;e\u0026#x27;。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.30.6","file":"catalog-pg-init-privs.html","lang":"en","sha256":"3f3fb9e6693f3909013c0cf90e80c971428ce6eff1d36b0a9231df064dfd6a59","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","objsubid","privtype","initprivs"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-init-privs.html","sha256":"09e83ad631f63dc5914d037a918f4f04d3b174a91351a293cf4f674da26c2b0d","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:903db91f7600be047cb5a67709c442cf8310f805ae48e55649d252ac064e8af4","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.30.6","file":"catalog-pg-init-privs.html","lang":"en","sha256":"3f3fb9e6693f3909013c0cf90e80c971428ce6eff1d36b0a9231df064dfd6a59","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-init-privs.html","sha256":"09e83ad631f63dc5914d037a918f4f04d3b174a91351a293cf4f674da26c2b0d","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:903db91f7600be047cb5a67709c442cf8310f805ae48e55649d252ac064e8af4","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","objsubid","privtype","initprivs"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_init_privs","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_init_privs","Summary":"The catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the database which has a non-default (non-NULL) initial set of privileges.\n\nObjects can have initial privileges either by having those privileges set when the system is initialized (by initdb) or when the object is created during a CREATE EXTENSION and the extension script sets initial privileges using the GRANT system. Note that the system will automatically handle recording of the privileges during the extension script and that extension authors need only use the GRANT and REVOKE statements in their script to have the privileges recorded. The privtype column indicates if the initial privilege was set by initdb or during a CREATE EXTENSION command.\n\nObjects which have initial privileges set by initdb will have entries where privtype is 'i', while objects which have initial privileges set by CREATE EXTENSION will have entries where privtype is 'e'.","BodyHTML":"\u003cp\u003eThe catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the database which has a non-default (non-NULL) initial set of privileges.\n\nObjects can have initial privileges either by having those privileges set when the system is initialized (by initdb) or when the object is created during a CREATE EXTENSION and the extension script sets initial privileges using the GRANT system. Note that the system will automatically handle recording of the privileges during the extension script and that extension authors need only use the GRANT and REVOKE statements in their script to have the privileges recorded. The privtype column indicates if the initial privilege was set by initdb or during a CREATE EXTENSION command.\n\nObjects which have initial privileges set by initdb will have entries where privtype is \u0026#39;i\u0026#39;, while objects which have initial privileges set by CREATE EXTENSION will have entries where privtype is \u0026#39;e\u0026#39;.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:329a318f31f2ac09f9fd593a7d3c5cc9b9f5238eb23cfddb8eec3a8aead3ebe2","ContentHash":"f82acb7af9bf7e14204eb333358e1179f8306be86bb5cc50a1550d64a4aabe8b","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the specific object","description_zh":"指定对象的 OID","documented":true,"documented_name":"objoid","hidden":false,"name":"objoid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the system catalog the object is in","description_zh":"对象所在的系统目录的 OID","documented":true,"documented_name":"classoid","hidden":false,"name":"classoid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"For a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero.","description_zh":"对于一个表列，这里是列编号（objoid 和 classoid 指向表本身）。对于所有其他对象类型，这列为零。","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"A code defining the type of initial privilege of this object; see text","description_zh":"定义此对象初始权限类型的代码，见文字说明","documented":true,"documented_name":"privtype","hidden":false,"name":"privtype","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":5,"description":"The initial access privileges; see Section 5.8 for details","description_zh":"初始的访问权限，详见第 5.8 节","documented":true,"documented_name":"initprivs","hidden":false,"name":"initprivs","not_null":true,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034,"zh_from":"same-version-manual"}],"description":"The catalog pg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the database which has a non-default (non-NULL) initial set of privileges.\n\nObjects can have initial privileges either by having those privileges set when the system is initialized (by initdb) or when the object is created during a CREATE EXTENSION and the extension script sets initial privileges using the GRANT system. Note that the system will automatically handle recording of the privileges during the extension script and that extension authors need only use the GRANT and REVOKE statements in their script to have the privileges recorded. The privtype column indicates if the initial privilege was set by initdb or during a CREATE EXTENSION command.\n\nObjects which have initial privileges set by initdb will have entries where privtype is 'i', while objects which have initial privileges set by CREATE EXTENSION will have entries where privtype is 'e'."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}