{"Entry":{"collection":"catalog","key":"pg_seclabel","name":"pg_seclabel","aliases":[],"metadata":{"changed_in":["9.5"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","order":false,"removed":[],"status":"added","to":"9.1","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.2","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.3","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.3","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.4","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"not_null","from":false,"name":"label","to":true},{"attribute":"not_null","from":false,"name":"provider","to":true}],"description_changed":true,"descriptions":[],"from":"9.4","listing":[],"order":false,"removed":[],"status":"changed","to":"9.5","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.5","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.6","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"10","listing":[],"order":false,"removed":[],"status":"reworded","to":"11","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"11","listing":[],"order":false,"removed":[],"status":"reworded","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"17","listing":[],"order":false,"removed":[],"status":"reworded","to":"18","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":5,"content_hash":"b944bab872c5befc63647d78ad6bf1f5e6a51b7756a6158bc678b3777734c36d","derived_content_hash":"e286b73823cd1cdc9ecb4b96a5070eace878ce5137e8ec81a7ece0bef7357446","first_version":"9.1","imported_at":"2026-09-30T00:40:55.786697+08:00","kind":"catalog","last_version":"20","name":"pg_seclabel","position":70,"present_in":["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":"r","shared":false,"source_rev":"catalog-bilingual-repair:c72ccdb37479b0315eaa01b1e444a47259830c9042e7e027abc8cc047dc4d751","summary":"The catalog pg_seclabel stores security labels on database objects.","summary_zh":"目录 pg_seclabel 存储数据库对象上的安全标签。安全标签可以通过 SECURITY LABEL 命令操纵。查看安全标签的更简单方法请见第 53.25 节。"}},"Definition":{"Collection":"catalog","Key":"pg_seclabel","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_seclabel","SourceRevision":"catalog-bilingual-repair:c72ccdb37479b0315eaa01b1e444a47259830c9042e7e027abc8cc047dc4d751","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the object this security label pertains to","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 this object appears 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 security label on 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 指表本身）。对于所有其他对象类型，本列为 0。","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":"The label provider associated with this label.","description_zh":"与该标签相关的标签提供者。","documented":true,"documented_name":"provider","hidden":false,"name":"provider","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"The security label applied to this object.","description_zh":"应用于该对象的安全标签。","documented":true,"documented_name":"label","hidden":false,"name":"label","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, see Section 53.23.\n\nSee also pg_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster.","description_zh":"目录 pg_seclabel 存储数据库对象上的安全标签。安全标签可以通过 SECURITY LABEL 命令操纵。查看安全标签的更简单方法请见第 53.23 节。\n\n同时请见 pg_shseclabel，它对集簇共享的数据库对象的安全标签执行相似的功能。","description_zh_html":"\u003cp\u003e目录 pg_seclabel 存储数据库对象上的安全标签。安全标签可以通过 SECURITY LABEL 命令操纵。查看安全标签的更简单方法请见第 53.23 节。\u003c/p\u003e\n\u003cp\u003e同时请见 pg_shseclabel，它对集簇共享的数据库对象的安全标签执行相似的功能。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.48.5","file":"catalog-pg-seclabel.html","lang":"en","sha256":"21b88cbdc30b05bb7080225a8b5fca68bac604ab9d6933c3b40ec506c2487a30","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","objsubid","provider","label"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-seclabel.html","sha256":"b1765d32b7802bfaa3974356c585d5748d20ce7c48ac34563f793911319bd8fc","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:56c0a78968359a41fef4d9dfa28379fc30e32ec76fbf7e1dcabc939d70f2685f","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.48.5","file":"catalog-pg-seclabel.html","lang":"en","sha256":"21b88cbdc30b05bb7080225a8b5fca68bac604ab9d6933c3b40ec506c2487a30","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-seclabel.html","sha256":"b1765d32b7802bfaa3974356c585d5748d20ce7c48ac34563f793911319bd8fc","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:56c0a78968359a41fef4d9dfa28379fc30e32ec76fbf7e1dcabc939d70f2685f","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","objsubid","provider","label"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_seclabel","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_seclabel","Summary":"The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, see Section 53.23.\n\nSee also pg_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster.","BodyHTML":"\u003cp\u003eThe catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, see Section 53.23.\n\nSee also pg_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:c72ccdb37479b0315eaa01b1e444a47259830c9042e7e027abc8cc047dc4d751","ContentHash":"880653320c9785e768a372932debe2634e004f035c385b95b0d5f09c4ac66f93","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the object this security label pertains to","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 this object appears 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 security label on 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 指表本身）。对于所有其他对象类型，本列为 0。","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":"The label provider associated with this label.","description_zh":"与该标签相关的标签提供者。","documented":true,"documented_name":"provider","hidden":false,"name":"provider","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"The security label applied to this object.","description_zh":"应用于该对象的安全标签。","documented":true,"documented_name":"label","hidden":false,"name":"label","not_null":true,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, see Section 53.23.\n\nSee also pg_shseclabel, which performs a similar function for security labels of database objects that are shared across a database cluster."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}