{"Entry":{"collection":"catalog","key":"pg_shseclabel","name":"pg_shseclabel","aliases":[],"metadata":{"changed_in":["9.5"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.1","order":false,"removed":[],"status":"added","to":"9.2","types":[]},{"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":4,"content_hash":"f64782f80a67830e6b5eb5df2d51a19a6ff55597da15077b6bfd863257b0b6d6","first_version":"9.2","imported_at":"2026-09-30T00:40:55.836058+08:00","kind":"catalog","last_version":"20","name":"pg_shseclabel","position":80,"present_in":["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":"english-manuals:028494bf0e48709c2ef74545a53b0c1c100447416d28a02b17237b1b62abc97a","summary":"The catalog pg_shseclabel stores security labels on shared database objects.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_shseclabel","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_shseclabel","SourceRevision":"english-manuals:028494bf0e48709c2ef74545a53b0c1c100447416d28a02b17237b1b62abc97a","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the object this security label pertains to","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 this object appears 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":"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},{"array_dimensions":0,"attnum":4,"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}],"description":"The catalog pg_shseclabel stores security labels on shared 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_seclabel, which performs a similar function for security labels involving objects within a single database.\n\nUnlike most system catalogs, pg_shseclabel is shared across all databases of a cluster: there is only one copy of pg_shseclabel per cluster, not one per database.","description_zh":"","doc":{"anchor":"id-1.10.4.52.6","file":"catalog-pg-shseclabel.html","lang":"en","sha256":"4ffe20426b8bd68263c8b9f4d08d754ff910040626358cd4d6763223f2e487a1","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","provider","label"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.52.6","file":"catalog-pg-shseclabel.html","lang":"en","sha256":"4ffe20426b8bd68263c8b9f4d08d754ff910040626358cd4d6763223f2e487a1","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","provider","label"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_shseclabel","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_shseclabel","Summary":"目录pg_shseclabel存储共享数据库对象上的安全标签。安全标签可以通过SECURITY LABEL命令操纵。查看安全标签的更简单方法请见第 53.23 节。\n\n另请参阅pg_seclabel，它对单个数据库中对象的安全标签提供了相似的功能。\n\n与大部分其他系统目录不同，pg_shseclabel在整个集簇的所有数据库之间共享：在每一个集簇中只有一个pg_shseclabel的拷贝，而不是每个数据库一份。","BodyHTML":"\u003cp\u003e目录pg_shseclabel存储共享数据库对象上的安全标签。安全标签可以通过SECURITY LABEL命令操纵。查看安全标签的更简单方法请见第 53.23 节。\n\n另请参阅pg_seclabel，它对单个数据库中对象的安全标签提供了相似的功能。\n\n与大部分其他系统目录不同，pg_shseclabel在整个集簇的所有数据库之间共享：在每一个集簇中只有一个pg_shseclabel的拷贝，而不是每个数据库一份。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"a91d21347a7d115c7065649c19c35cb540ebe147620daaab74c386b1534068f6","Payload":{"columns":[{"description_zh":"该安全标签依附的对象的OID","name":"objoid","type":"oid","zh_from":"doc"},{"description_zh":"该对象所在的系统目录的 OID","name":"classoid","type":"oid","zh_from":"doc"},{"description_zh":"与该标签相关的标签提供者。","name":"provider","type":"text","zh_from":"doc"},{"description_zh":"应用于该对象的安全标签。","name":"label","type":"text","zh_from":"doc"}],"description_zh":"目录pg_shseclabel存储共享数据库对象上的安全标签。安全标签可以通过SECURITY LABEL命令操纵。查看安全标签的更简单方法请见第 53.23 节。\n\n另请参阅pg_seclabel，它对单个数据库中对象的安全标签提供了相似的功能。\n\n与大部分其他系统目录不同，pg_shseclabel在整个集簇的所有数据库之间共享：在每一个集簇中只有一个pg_shseclabel的拷贝，而不是每个数据库一份。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}