{"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":"2b5a346d2b242f2ed66c23e8b7fbd131a7a0f128c60bf1743e277f7ac0bc93ff","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":"english-manuals:903db91f7600be047cb5a67709c442cf8310f805ae48e55649d252ac064e8af4","summary":"The catalog pg_init_privs records information about the initial privileges of objects in the system.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_init_privs","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_init_privs","SourceRevision":"english-manuals:903db91f7600be047cb5a67709c442cf8310f805ae48e55649d252ac064e8af4","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the specific object","description_zh":"","documented":true,"documented_name":"objoid","hidden":false,"name":"objoid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"The OID of the system catalog the object is in","description_zh":"","documented":true,"documented_name":"classoid","hidden":false,"name":"classoid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"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":"","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"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},{"array_dimensions":1,"attnum":5,"description":"The initial access privileges; see Section 5.8 for details","description_zh":"","documented":true,"documented_name":"initprivs","hidden":false,"name":"initprivs","not_null":true,"references":"","type":"aclitem[]","type_modifier":-1,"type_oid":1034}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.30.6","file":"catalog-pg-init-privs.html","lang":"en","sha256":"3f3fb9e6693f3909013c0cf90e80c971428ce6eff1d36b0a9231df064dfd6a59","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_init_privs","Summary":"目录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'。","BodyHTML":"\u003cp\u003e目录pg_init_privs记录系统中对象的初始权限。数据库中每个具有非默认（非 NULL）初始权限集合的对象都在其中有一个条目。\n\n对象可以在系统初始化（initdb）时获得其初始权限，也可以在CREATE EXTENSION期间创建该对象，并在扩展脚本中用GRANT设置对象的初始权限。注意，系统会自动处理扩展脚本执行期间对权限的记录；扩展作者只需要在脚本中使用GRANT和REVOKE语句，权限就会被记录下来。privtype列表示初始权限是由initdb设置，还是在某次CREATE EXTENSION命令期间设置。\n\n对于初始权限由initdb设置的对象，其条目中的privtype是\u0026#39;i\u0026#39;；对于初始权限由CREATE EXTENSION设置的对象，其条目中的privtype为\u0026#39;e\u0026#39;。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"388713c2a5a0fadc6d29f3868b2e1da11c0cd03b7a78e31b011dab55e6d28fa0","Payload":{"columns":[{"description_zh":"指定对象的 OID","name":"objoid","type":"oid","zh_from":"doc"},{"description_zh":"对象所在的系统目录的 OID","name":"classoid","type":"oid","zh_from":"doc"},{"description_zh":"对于一个表列，这里是列编号（objoid和classoid指向表本身）。对于所有其他对象类型，这列为零。","name":"objsubid","type":"integer","zh_from":"doc"},{"description_zh":"定义此对象初始权限类型的代码，见文字说明","name":"privtype","type":"\"char\"","zh_from":"doc"},{"description_zh":"初始的访问权限，详见第 5.8 节","name":"initprivs","type":"aclitem[]","zh_from":"doc"}],"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'。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}